Help With Auto Lookup!

Fisher31

Registered User.
Local time
Today, 02:18
Joined
Oct 7, 2009
Messages
11
Hi all,

I am having problems setting up auto lookups

I want my PurchaseOrder form to automatically fill in the name and address fields when a customers ID is entered. I understand that this will only work as part of a one to many relationship.

Where I am having problems is making it work on a form, When I link the two tables I can't seem to make it a one to many relationship (it just shows a straight line) and how do I physically make it fill in other boxs on the form.

I hope this makes sense as I seem to be having difficulties putting my problem in to words.
 
If you change the textbox into a combo box to select the customer id then you can use hidden columns in your combobox to populate the unbound textboxes on your form.
 

Users who are viewing this thread

Back
Top Bottom