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
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:
https://www.stl-training.co.uk/ms-access-training-courses-in-london-2003-vba.php
Regards
Jacob
