98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training courses - Form/Query Look up wizard
microsoft access training courses - Form/Query Look up wizard
Resolved · Low Priority · Version Standard
Thu 15 Mar 2007, 09:46Delegate Brian said...
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?
Fri 16 Mar 2007, 10:30Trainer Richard said...
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
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. |
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
