question| how to build my data base?

[mikichi]

hi,


i have a two kinds of users in my project - visitors and workers.
visitors users have the next column: ID, age, gender and name.
workers users have all of visitors column(i.e ID,age,gender and name) and workerID, family name and start day in project.

how i build my DB smart?
one table for both? (i.e the column: workerID, family name and start day in project always been empty for visitors users)?
or maybe one table for the commons column(ID, age, gender and name) and second table for the rest(workerID, family name and start day in project).

thank you very much!!!
miki

[AlexHedley]

You could have them all in 1 Table then hide certain Fields on a Form depending on their permissions level.

You could create two tables. With a 1-1 relationship then only allow certain users to see that data in another Form.

[mikichi]

i know, but what prefer?
thank you.
miki

[AlexHedley]

A separate Form would be easier to control, if you added more Fields at a later date you wouldn't need to amend much whereas hiding them would be a little more work.

[mikichi]

ok, so if i buid two table in 1-1 relationship. i must connect them with index column?

[AlexHedley]

Yeah just add the Primary Key in the first to the second as a Foreign Key.