Put client list into 2 tables

T

tflett

I have a client list and I want to be able to generate two tables from this
client list called Employee table and a Trainee Table. Would it be best to
have a drop-down list in the Client table table giving the options of
"Employed" & "Training"?
 
J

Jeff Boyce

Are you quite certain your Employees will never be Trainees? Not now, not
ever? Or vice versa?

Will this result in two identical table structures, with the only difference
being whose data goes in one table or the other? If so, why split?

It would NOT be a good idea to have a drop-down "in the ... table" at all.

Access forms are the place to have your users work with the data. And if
you want a drop-down (combo box control) in your form, why not have all in a
single table, but add an option group to the form that lets you pick
"Employee" vs. "Trainee"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top