I need to understand how relationships between Tables, those with data already in them and those waiting for data to be input into them are drawn.
For example you have a table of customers, and you need to have a combo box with a list of trucks to choose from for each customer or more than one customer for each truck, how does this work out in the relationships and the lines connecting them.
How does the form handle data input and how does one most accurately and efficiently get the input data into the appropriate tables? I know you need to change the control source and rewire the query, but it can get very frustrating at times.
Thank you everyone for your patience with me.
