Folks,
I am sure that this is simple for most of you, but I have not figured it out yet!
I have an activity table that I want to add new records to using a simple form. The activity table has a relationship with a customer master table via the customer number.
I would like to be able to use a combo box or some other technique to select the customer number and have Access pull data from the customer master table to populate the activity record. This allows me to use default data from the customer master record rather than to rekey the entries if there are no changes.
How can I do this?