>Gene,
>
>>In your grid's query put:
>>
>>SELECT blah, blah, blah ;
>> FROM blah ;
>> WHERE blah=?thisform.pageFrameName.listboxName.Value
>>
>>
>>Put in the InteractiveChange event of the drop-down:
>> thisform.pageFrameName.Grid.Refresh or Requiry
>
>I put the SELECT in the RECORD SOURCE and set the RECORD SOURCE TYPE to 4 - SQL. I then added code in the InteractiveChange even of the drop-down. Requiry doesn't work at all, it gives me an error. Refresh doesn't change anything either, but I don't get any errors.
>
>Any other suggestions? I made sure the proper column was BOUND in the drop-down by setting the CAPTION of the form to the value. If I hardcode a value in my SQL statement, the proper data comes in just fine. I must be doing something wrong.
>
>Also, I want to be able to UPDATE any tables that I joined using the SQL, is that possible?
>
>Thanks,

Jim,

Change it, make the select be a view in the DBC and make the RecordSourceType Alias and the RecordSource the name of the view. Also put th3e view in the DE for the fomr and make its NoDataOnLoad property .T.