In my database I used a field called Job_number as the key field in multiple tables. Table Job_Name connects to Job_Spec..Job_Spec connects to Job_Contract… Job_Contract connects to Job_Phases. Is it ok that I use the same key field in all? Even though I set up the relationships this way is it then ok to have Job_Spec connect directly to Job_Phases, etc. What is the best way to not confuse user friendly Access?
Thanks
Debbie
