Good morning, OK managed to start this now.
1 - Run DA wizard to create tblContacts - ContactID | ContactName | ContactDate | ContactAssignedTo
2 - Open tblConactsinsert.php in DW, add manual fields for input data to tblCases - CaseID | ContactID | CaseType | CaseDate | CaseStatus
3 - Server Behaviours Panel - Data Assist | Insert | Insert Single Record
4 - Select tblCases, Key Column 'CaseID', complete table field values by selecting the manual fields I just created on the form, example [<?php echo ((isset($_POST["CaseType"]))?$_POST["CaseType"]:""); ?>]
5 - Open 'insert record [tblContact]', key column is 'ContactID' & Store As 'WADA_Insert_tblcontacts'
6 - Open 'insert record [tblCases]', key column is 'CaseID' & Store AS 'tblcases_CaseID', go to ContactID from tblcases and set value as 'WADA_Insert_tblcontacts'
The records get inserted on both tables which is great but on the tblCases side there is no ContactID leaving the cases unassigned to anyone. I am guessing the binding is in the wrong place but cannot fathom where it should go?
Worth noting that the 'ContactAssignedTo' field from tblContacts is the field that will link to the case? I need the ID that is selected from that field to also insert into ContactID field of tblCases.
For example, if user selected 'John Smith' from the menu on 'ContactAssignedTo' this would insert ContactID 100 into both tblContacts.ContactAssignedTo & tblCases.ContactID
Sorry for all questions, I think I am nearly there!