I have a bizobj with 3 views:
- v_Rentals
- v_Contracts
- v_Sublets

v_Rentals is the primary view for the form.
v_Contracts is source for a combobox.
v_Sublets is the source for another combobox.

v_Sublets has a parameter vp_conpk that will only query the Sublets for the selected Contract.

The form in which this all lives is a NOLIST maintenance form with a find form.

How do I set this up properly so that all contracts are shown, but only the sublets for the selected contract are shown in the second combobox? And how should I determine that the second combobox should be "cleared" of the user's choice when the first combobox changes?

...John