>I'm looking for a simple way to compare the structures of a number of tables. I think they are the same, but there are 200+ fields and I would rather sit and write code for two hours rather than sit and stare at paper for two hours. I'm playing around with the AFields() function, but can't quite get the concept going of what I need to do... Any ideas? Thanks!
>
>Regards, Renoir
Renoir,
Have a For-loop on both tables, looking at all the FIELD(I) while .not. '', and put the name, type and len of the fields in a temp-table (in fact two).
Now compare both tables.
Looks simple, but we use kinda this in order to automatically upgrade tables at the customer's site.
HTH,