Web Development



Going Crazy with ACCESS

By jburkettster ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

partial answer

by john.a.wills In reply to Going Crazy with ACCESS

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.

Related Discussions

Related Forums