Best practice for table design

[Debra Farnham]

Hi Bruce

I suppose I wrongly assumed that one could follow the pattern in my design.
Since strWorkOrderNumber appeared in most tables where a one to one
relationship existed and the remaining tables all had an autonumber field
(which I only ever use as a primary key as it has no real meaning to a
user), I thought it would be easy to sort out. I suppose I was mistaken.

Thank you for your advice. I will bear that in mind in future posts.

Debra