Denys Beauchemin wrote:
> If you can totally control the numeric key values that would be used as a key
> in a master dataset, then by all means investigate the possibility of using
> this key as a numeric key.  You may be able to have a data set with all
> primaries, giving you 100% utilization if needed and the fastest access
> possible.

Agreed 100%.

In my previous life at cccd.edu, all of the student records data was stored in
Omnidexed Image masters with integer keys.  Omnidex makes it easy to control
the key values; IIRC, doing an Omnidex DBIPUT with a key value of -1 tells
Omnidex to use the next unused key value instead of the -1 (Omnidex keeps a
table of the unused key values).

- Mark B.