Find Fields

[chefsride]

I have a database that has many tables and some of the tables have a field that determines something about the record. I want to find the tables that have that field. The problems is that the field name is not the same in each table as the field name is table_something. The something in the field name is the same and the table in the field name is the name of the table. I want to find the tables that have that something in the field name. Can anyone help me.

 

[Lee Curzon]

You need something like:

for each _file no-lock:

if can-find(_field of _file where _field._field-name = (_file._file-name + '_something'))
then display _file._file-name.

end.