Put client list into 2 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Should I split tables 3
Filter into a subform 1
Training Report 2
Simple Methods to Export Gmail to Text? 1
Show/Restrict records using criteria across on multiple records. 1
VBA - retrieve data on last create named range from previous inserted named range 0
Complicated query 11
How to Create Tables Automatically? 1

Back
Top