Hi
I have built a form with several fields from different tables (related) that does what I want it to. I now want to make an adjustment to fine tune the form. Ok, here’s the bit I’m confused about! On the form are two fields Campaign and Event. These two fields are combo boxes that simply allow a user to select which Campaign and Event respectively. The Campaigns and Events tables are related. What I want to do is have a user select a Campaign then only the Events (that are related to the selected Campaign) be offered for selection. What is the condition/expression I should use?
Campaign Table...
ID
Name
Desc
Events Table...
ID
Name
Desc
Related Campaign (related to Campaign.ID)