AnsweredAssumed Answered

Most normalized approach to creating contact fields for multiple tables

Question asked by astep7579 on Dec 28, 2018
Latest reply on Dec 29, 2018 by TorstenBernhard

What is the most efficient approach to setting up multiple tables when each has the same contact information fields? i.e., employee addresses, client addresses, supplier addresses

 

1. Should employees, clients and suppliers have their own address fields in their tables?

 

2. Should the common fields for all the above be placed in the same table?

Outcomes