D
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
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