>>However, Let's say I don't know value of what is located in the fieldname I am interested in until run-time. In this case, can I set a variable for the table.fieldname in my WHERE statement?
>>
>
>This is like a Query By Form issue. There was an article in FoxAdvisor about how to do this. Basically, you can change the WHERE of a view... What you can do it build the whole SELECT statement at runtime... This is a got bet for lookups and such...
>
>If you are using remote data, you can use SPT to send the select statement to the back end.
>
>BOb


QBF Builder from www.classycomponents.com makes this a piece of cake.