Linking a field to multiple tables based on another field's input

P

PsyberFox

Hi there,

Let me explain the subject line:
I have a field (dropdown box) where the user can select a department. Based
on the selected department, two things must happen. Firstly another field
called machine number, must only be available for 2 of the departments. And
secondly, based on which one of the two, the machine number for department 1
or department 2 must be available for the MachNo field. In other words, when
selecting department 1 a table with department 1's machine numbers must be
available, and likewise for department 2... with a separate table with it's
machine numbers. How would I go about doing this?

Thank you!
 
S

scubadiver

If this *is* what you are after you don't need a separate table for each
department. ave a one to many relationship between two tables (one for
department and one for machines)
 

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

Form creates unwanted rows in table 1
After Update / Requery / Blank Fields 2
Form opens based on unique ID 2
Filtering a combo box on a subform using a value from the main for 3
Make fields dependent on option of another 3
Restricting Access to Certain Information 3
Access Switchboard error message 1
Populate cbo based on another cbo value 7

Top