Brian has attended:
Access Intermediate course
Access Advanced course
Form/Query Look up wizard
It is possible when building a form to select specific data from a table to appear as a drop down list when inputting new records, is it possible to select different items from different tables to appear in this drop down list?
RE: Form/Query Look up wizard
Brian, thanks for your question.
It can be done, and you need to have the ability to use relationships, foriegnKey, abit of SQL and join types. Even as an Access trainer and user, I would find this fairly complex, and it would take some time to to get working.
Basically you need to create a relationship between the two tables, one on the Primary key, and the other on the ForeignKey. Then create a Query using a UNION JOIN (SQL) to select all records from both tables.
Richard
