Posted by Robert G Laurin on August 13, 2007 at 19:35:51:
In Reply to: Re: Coding CreateKey posted by Barbara Brazil on August 13, 2007 at 15:19:30:
Barbara wrote:
"Yes, the offsets of the keys in the record are relative to zero. Also, remember that keys are not the same thing as fields. A key may span more than one field."
This may be true, but the key that span more than one field has to be in a single chunk, right? If so, using multiple keys would require the data to be duplicated for each instance. For example I may have out of CustomerMaster the primary key as CustNumber$ and secondary keys as ZipCode$+CustNumber$ and AlphaName$+CustNumber$ and PhoneNumber$+CustNumber$. since ZipCode$, AlphName$ and PhoneNumber$ are already in the data, I need to duplicate them to build secondary keys, right?
Jim's original idear to append the primary key to secondary keys would had made this so much easier. And that is just my opinion.