I am creating an access database and am trying to link two tables and utilize a form in adding and updating info within these tables. I have successfully created a relationship, but i can't seem to get an ID number created in the equipment table that matches the ID number created in the main table so the data between the two forms/tables are linked.
My desired output is to create a record in the main form, then when i click on the equipment button on this form, the data entered on that form correlates to the data on the main table.
I have attached a copy of my database so you can see what i have created so far. Let me know if you need additional information.