🚀 go-pugleaf

Hi,

I have a grid that contains the fields of table1.  Two of the fields of
table1 are key fields of table2 and table3.  Table2 is the parent of
table3.

I am using a lookupSQL on keyfield1 with a combobox to provide the user
with a list of valid choices.  Everything works fine here.

My problem is that I want keyfield2 to list in its combobox only those
'detail' records that exist for the parent selection, keyfield1.  In sql
terms I would like to see... Select Keyfield2 from table3 where keyfield2 =
keyfield1.

I have been unsuccessful trying to use a varaiable for keyfield1.

I have also tried working at the problem using lookuprowset to populate the
combobox, but I cannot get around "DB7 - Internal Errors".

Passing a parameter is the likely the solution, but I need some help on
using them.
I would appreciate any assistance provided.

Thanks.

Lawrence Bain