Yes, GETPROPERTY returns text so try: WHERE episode# = (int(.vepisode))
Claudine :-) _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Monday, January 28, 2008 8:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: another Form question I seem to be missing something. When I do the following, the second combo box is blank, no matter what I enter in the first! My field Episode# is an Integer. Would that have anything to do with it? Lin On Sun, 27 Jan 2008 21:17:55 -0600, "Claudine Robbins" <[EMAIL PROTECTED]> said: 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
