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 / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Secondary lookup table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bikeet2capt - 14 Mar 2006 14:27 GMT
I know how to pick from a lookup table to insert information into a column.  
Based on the selection in the first column, I would like to have different
lists available for a second column.  For example, column A would have a
lookup table with "flow switch" and "level switch" as the available picks.  
When filling out Column B, if "flow switch" is picked for column A, a lookup
table with "target type" and "pressure type" would be available.  But if
"level switch" is picked for column A, "float type" and "conductivity type"
would be available.  Thanks.
Larry Daugherty - 14 Mar 2006 15:10 GMT
The Northwinds sample application supplied with Access provides an
example.

HTH
Signature

-Larry-
--

> I know how to pick from a lookup table to insert information into a column.
> Based on the selection in the first column, I would like to have different
[quoted text clipped - 4 lines]
> "level switch" is picked for column A, "float type" and "conductivity type"
> would be available.  Thanks.
 
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.