Multiple Form Data Entry

[crashnburn99]

Good afternoon! I am working on a project that has 5 tables. The primary being the customers table and the rest being addresses, schedules, tenants, and unit info. I separated the address table because some of the clients have multiple addresses. Seeing how everything revolves around my customers table I have included a "CustomerID" field in every other table to link them to my customers primary key. I created a main form with a tab control, each tab contains a sub form of each table. I added some dummy info into the tables just to make sure everything would pull the way it is suppose to and it does. Here is the issue, whenever I enter in a new customer it never pulls the "CustomerID". So I will have all the information in the tables but it will not be linked together. I have checked the sub forms and made sure that the "Link Master Fields" and "Link Child Fields" are correct, they are. I am at a complete loss as to where to go from here. Any help would be greatly appreciated. If I left any needed info out let me know and I will post it. Thank you.

 

[JHB]

How do you create the "CustomerID"?

 

[crashnburn99]

It is a Number data type in the table to coincide with ID in the customers table, which is a AutoNumber. In the forms I have it as a text field, CustomerID, that is not visible. In terms of actually creating that number in the form during data entry I assumed that having it linked to the ID field in the customers table, it would auto pull it. I do not know a way to get the ID from the customers field into the Customer ID field of the form , I feel this is where all my problems stem from.

 

[crashnburn99]

Solved the problem. I had created a customers form before I decided that I would like a tab control. After I created the tab control I dragged the customers form into the tab control to save time, but in doing so it made it a sub form. There was no info from the main form for the other sub forms to pull from. Thank you very much JHB for talking the time to try and help.