You can use FCOUNT() to get the number of fields in the table, FIELDS() to get a field name by its position, AFIELD() to get the table fields into an array. To check if field 'myfield' exists in the alias 'mytable',

? TYPE("mytable.myfield") <> "U"

>Is there a way to determine if a person chooses the right table? I mean when the user gets a GETFILE('DBF') and he/she chooses a VFP table. How can I check if it's the right table (I need in that specific procedure) the user have chosen? I think I can check the structure of the table, but how can I do that? Anybody have an idea?
>