>My PK field is always name TableId, so in a Customer table, it would be CustomerID. That fieldname flows through to all other tables that use it.

Oh, of course! I was forgetting the most important reason for repeating the table name in the key field name. Otherwise foreign keys must have a different name from the primary key field they refer to.

So you say "CustomerId" and I say "iCUSTOMER"! [BG] (I always capitalize references to table names.]


>Also, I never, ever use underscore. Too difficult to type. I can use upper/lower case to differentiate enough.

I agree. See point 14 in document "VFP Development Do's and Don'ts".

Peter