Exucse me for asking what seems like an easy question, but I do not seem to be able to do the following:
I have created tables within a database that all have a primary key of First_Name and Last_Name. One of the functions I have on a form is for a user to be able to add a new First_Name and Last_Name into the system.
I can get the form to add the record to the table the form is linked to, but not to the other tables (probably because my programming skill is very limited).
I attempted to place code into the OnClick Event to add the records with no success. How can I add new records to the additional tables even though the form is only tied to one specific table source?