Combo box to limit selection based on current record in form

L

laskowv

I want my combo box to only display the valid ranges from a table that match
the PK in my current form. Here are my tables:

Division
DivisionID PK
DivTerms

Terms
TermID PK
TermEndDate

Division Terms
ID PK
DivisionID FK
TermID FK

The goal is to have the combo box to to list the valid term end dates for
the specific division record that I am on in the form. For example, if I'm
on Division 1 (California); then I want the combo box to display the terms
from table Division Terms (which is linked to the Terms table to display the
TermEndDate); and then bind the TermID from Division Terms table into
DivTerms field in the Division table.

Where I'm having trouble is trying to only display records from the Division
Terms table where DivisionID = DivisionID on my form.

Thanks..Valerie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need count of divisions and number of employees within division 2
4 Fields PK linked to 1 field FK 9
The Biggest Design Problem - HELPPPPP! 4
How I pass a value from a form to a subform? 1
Default value of combo box based on another combo box 6
Need help cascading 5 combo boxes 12
Need combo box to refresh when moving to new record 2017 1
Create new record in diff table 1

Top