Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training courses - Form/Query Look up wizard
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access training courses - Form/Query Look up wizard
Resolved · Low Priority · Version Standard
Reply
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?For upcoming training course dates see: Pricing & availability
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
|
 |
|
» Forum post: Word Functions |
How do I use the drawing shapes etc facility in Word?
