I just noticed that the Equates created from the table builder assign a zero to key prompts even for multi-part keys. I assumed it would create equate key1 to 1, equate key2 to 2. Has it always been this way? What purpose is equating the key field(s) to zero?

Thanks,

John

John,

Yes, it has always equated keys to position 0. The equates is created setting the TO as the Field number as defined in the %FIELDS% record in the Dictionary therefore:

EQU ID to 0

EQU F1 to 1

EQU F2 to 2.

Sean

View this thread on the Works forum...