Evening gents, each case will have 1 client & 1 'salesperson', the salesperson can have many clients and many cases.
I have run the DA wizard on the tblCases first then was going to go DA > Insert > Insert Single Record based on the tblContacts. You suggested doing this with tblContacts as first insert, does that make a difference?
Would I need to add the required form fields manually before creating the 2nd insert record as I cant seem to add the fields I want from tblContacts? Only option I get for field value is the pages form fields, which currently don't have any fields from the tblContacts? I need to add fullname, contactid, staffid fields from tblContacts?
Sorry to keep asking, I am sure once I understand the process I will be fine and can use the example throughout my project.