there are a couple of helpful functions you'll find in the Table
Functions section of the Reference Manual:
FieldName(n,'TableName') - gives you the name of the (n)th field
in your table.
NoOfFields('TableName') - gives you the number of fields in your
So, you should be able to use these together to load-in the names of all
your table's fields.
The where clause
Where RecNo() = 0;
also worked to load only tables and fields with no data and returned this
If you need to work with the table names and field names in QV objects (i.e. list boxes) then use $Table and $Field system fields.
In this example I counted number of unique values in each field.