Hi,

I am having some issues with attachments. I have two tables. Projects and projectattachments. For example, when an email from outlook gets loaded to my tables , a record gets first created in the projects table and then it should create a record in the projectattachment table with the projectid from the parent table.It always has the wrong projectid in the child table. I have set the parent table Mappings under Item attahcments. Should I also have queries under the second grid (Execute SQL-Statement to retrive a new primary/mandotory key)

You don’t need queries in second grid (this is for columns with mandatory values).

Please install the examples and investigate the example configuration.
(You can use MS Access example for mail and mail attachment).

Check also your primary key definition and SQL Statement in parent table (Assign Table->Mandatory keys)