Forum Discussion
Table structure
Hi Looking for some advice please on how best to structure tables. I have a 'Person' table which contains the name and contact details of various persons associated with our organisation. Some of...
The best approach may depend on how many additional fields you would need for employees and the relative number of employees compared to other people (clients/customers?).
Also some people could be both employees and customers.
Will you need additional fields for those who aren't employees?
If you decide on a separate table for the additional fields you can link it to the primary key field in your persons table
Also some people could be both employees and customers.
Will you need additional fields for those who aren't employees?
If you decide on a separate table for the additional fields you can link it to the primary key field in your persons table