Dynamic can-find, how can I do this?

[Emma]

I have a table that holds label text in one field, and then a program name and table name in the second field, comma seperated

What i need to do is as follows:


IF CAN-FIND(FIRST tablename WHERE tablename.field = cField)
THEN "Y"
ELSE "".

where tablename is the entry 2 value returned from the second database field.

How can i build up the can-find dynamically, so that it pulls the values from the database table to build up the code?

Thanks,

Emma.