born2gamble
Registered User.
- Local time
- Today, 13:59
- Joined
- Aug 16, 2011
- Messages
- 31
Hi...new to Access, but learning..
I have a small issue that I havent been able to figure out yet.
Its a transportation business, so one customer can have several different pickup locations.
I have 2 tables
Customer table
Order Table
Is it possible to have an orders Form, where a user can search for companyA in a subform (basically this http://www.access-programmers.co.uk/forums/showthread.php?t=188663), where all the locations are shown for that company, then click the appropriate location, and have that info auto populate on the appropriate text boxes ( Address/ City State etc)
If this is possible, how would I go about linking the search results to the appropriate fields?
Thanks in advance
I have a small issue that I havent been able to figure out yet.
Its a transportation business, so one customer can have several different pickup locations.
I have 2 tables
Customer table
Order Table
Is it possible to have an orders Form, where a user can search for companyA in a subform (basically this http://www.access-programmers.co.uk/forums/showthread.php?t=188663), where all the locations are shown for that company, then click the appropriate location, and have that info auto populate on the appropriate text boxes ( Address/ City State etc)
If this is possible, how would I go about linking the search results to the appropriate fields?
Thanks in advance