I am getting confused with a database that I have started working on. I have 4 tables; Customer (PK Customer_ID, 1:M with System Table), Service (PK Service_ID, M:1 with System), Inspection (PK Inspection_ID, M:1 with System) and System (PK System_ID) The system table contains System_ID, Customer_ID, Service_ID and Inspection ID. I want to pick a customer number from a combo box and then proceed with the data entry in another form. I type the information pertaining to the tables but the ID numbers does not get saved in the System table. I can ,however, receive existing data in a report or query. How or can I fix this problem? If I can not fix the problem how can I approach the table design?
