Issue Having Multiple Tables On One Form

[CecileyB]

I am creating a muster report for where I work. The goal is to have a main form that shows the date and time of when each work center submitted their individual muster report and who it was submitted by. It works perfectly fine until more than two tables are being added to the form. The fields will populate the information but when I close out of the database and open it back up the fields are empty again, but it stayed when there were only to tables involved. Each work center has their own separate form based off of their own table of applicable personnel. I've attached a screenshot to better show you what I'm talking about.

Each table has a 'date and time modified' and a 'entered by' column, and each form has a 'submit' button and an entered by block for the user to enter their name upon submission. The 'entered by' block is pulled from that work center's table. The date and time field and the entered by field is pulled off of each work center table and added into the main form. All of the tables are linked together by the ID field.



Does the form have to be formatted a certain way for it to be able to manage information from that many tables? I have it currently on Dynaset(inconsistent) for the record set type.

[June7]

Recommend you have 1 table instead of 14 tables and only 1 form. Apply filter criteria based on who is using the db.

Why are two tables linking on Rank? Is that an error?

Are the ID fields all autonumber type? Cannot link autonumber to autonumber.