So is it ok to have PK's and FK's on columns like ProductNumber that are
used to lookup product descriptions?
I also use PK and FK's on Custnum, is that OK too? I am getting worried
about my db structure.
Thanks
Marc
Also a lesson learned in history is never put any information into a PK
My personal practice is to use a PK on every table that is system
assigned, and I never worry about gaps in the sequence. The advantage to
the random approach is that with this approach the PK contains no data
or any item resembling data. This approach makes things a bit more
normal that the other approaches.
