Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries
|
|
|
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. |
Queries
Resolved · Urgent Priority · Version 2003
Reply Wed 3 Dec 2008, 12:44Delegate Michael said...
Michael has attended:
Access Intermediate course
Queries
Hi,
I have 3 tables
- Risks
- Overview
- Business Units
The risk and Business unit tables are joined... through the business unit field
The overview and Busniess Unit tables are joined ... through the business unit filed
What i am trying to achieve is to open the overview table, select a business unit (from the listbox of all business units in teh busniess unit table)...and have the risk field of the overview table (Not linked to anything currently) be populated with all risks from the risk table, which have the corresponding business unit.
eg) Have select "Legal" business unit in the Overview Table.... and have the risk field in the overview table be populated with the "Legal" risks from the risk table.
Is this done ina query?
Mike
For upcoming training course dates see: Pricing & availability
RE: Queries
Hello Mike
Thank you for your post. One of our Access VBA trainers has reviewed your post and recommends that the quickest way to gather the knowledge to achieve your objectives is to attend our 2 day MS Access VBA course.
Please follow the link for more information on this course:
http://www.microsofttraining.net/ms-access-training-courses-in-london-2003-vba.php
Regards
Jacob
Mon 15 Dec 2008: Automatically marked as resolved.
|