Keith Nichols
Registered User.
- Local time
- Today, 10:45
- Joined
- Jan 27, 2006
- Messages
- 431
I want to filter a form based on the many side of a 1 to many relationship to the records on the form
The form shows projects which can be associated with more than one asset. There is a junction table to hold the asset assignments with a many to 1 relationship to the project details table.
What I would like is to use a combo box to select an asset and only show projects having an association with that asset. I cannot add the appropriate field to the query as this causes projects to appear for every assinged asset which in turn upset the reporting.
At my skill level and experience, I can't see how this could be done. Any body have any suggestions?
The form shows projects which can be associated with more than one asset. There is a junction table to hold the asset assignments with a many to 1 relationship to the project details table.
What I would like is to use a combo box to select an asset and only show projects having an association with that asset. I cannot add the appropriate field to the query as this causes projects to appear for every assinged asset which in turn upset the reporting.
At my skill level and experience, I can't see how this could be done. Any body have any suggestions?
