In a standard R:Base variable lookup in a form you can type vMyVar = MyColumn IN MyTable WHERE MyIDCol = MyIDCol
and R:Base inteprets the where clause to use the value in MyIDCol of the current row of the form. If you do the same thing in a list box or combo box lookup, R:Base instead interprets the WHERE clause is the standard, at-the-R> Prompt way and returns all rows (since MyIDCol always equals MyIDCol in the lookup table, assuming there are no NULLs). Is there any way to use a column from the form's driving table directly in defining the WHERE clause of a list object, or do you have to put the value into a variable and then use the variable? -- Larry
