I have attached a simplified version of my database for an example
frmInspections is where my problem lies at this time, if you add a new inspection (or edit an existing one) the data being entered in tblInspections is recorded correctly
However if you select a client or an inspector then it is also adding this data again to the respective tables ie tblClients and tblInspectors
what am I coding wrong so that it does not get re-entered as a duplicate in these tables and just the foreign key is entered into the correct table?
Thanks
Attachment 5009