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

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!

I think you are after "cascading combos". There are loads of queries on this.

"PsyberFox" wrote:

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!

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)

"PsyberFox" wrote:

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!