Web Development

Ask something
Question Locked

Going Crazy with ACCESS

0 helpful
2 replies

by jburkettster

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by john.a.wills

In the customers table should be a field with the truck code. In the truck table the truck code should probably be the key. When the user chooses a truck from the combo box, VBA code should put the truck code in the customers table.

This discussion is closed to new replies.