Re: [MS_AccessPros] Normalizing table

 

Good morning and thank you Mr. Viescas

After removing the fields that belong to other tables, I have tried 2 different ways to link the tables back together. My first tried was, I linked the SalaryInfo table to the EmplInfo table by adding a SalaryID to the EmplInfo table then linked the SalaryID from both tables. The second method was, create a third (bridge?) table and put the SalaryID, SupervisorID…  then link the EmplInfo table to the Salary table, Supervisor table... through the bridge table. So far there was no errors occur. However, which method is better or appropriate than the other? Or 1 is wrong and the other is correct.

Thank you

Phucon.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___