Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PsyberFox - 15 May 2008 12:45 GMT
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!
scubadiver - 15 May 2008 13:21 GMT
I think you are after "cascading combos". There are loads of queries on this.

> Hi there,
>
[quoted text clipped - 9 lines]
>
> Thank you!
scubadiver - 15 May 2008 17:00 GMT
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)

> Hi there,
>
[quoted text clipped - 9 lines]
>
> Thank you!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.