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.
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.