Lin,
Create a component id on the first combo box. On exit from the first combo box, grab the value that the user has picked: SET VAR vepisode TEXT = NULL GETPROPERTY componentidoffirstcombobox TEXTVALUE 'vepisode' In second combo box use: WHERE episode# = .vepisode Claudine :-) _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Sunday, January 27, 2008 7:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - another Form question I have a form that loads a table: RUNCOST The User enters an Episode# (they choose from a LookUp ComboBox on table EPTOTALS). The next field that the User must enter is Set#. I would like them to choose using another LookUp CombBox, choosing the Set # from table BUDGET where the Episode# they just entered matches an episode# in the table. I'm not sure where, or how, to enter the Where clause. So far, I keep getting my DBComboBox populated with all of the Set#s in the table. Episode 1000 contains set #s 1-99, Episode 2000 only has set#s 1-9. If the User has chosen Episode# 2000 in the field just before, I don't want him to be able to choose Set# 55. thanks, Lin
