|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 14th, 2006, 01:27 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Secondary lookup table
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. 
|
|
#2
March 14th, 2006, 02:10 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Secondary lookup table
The Northwinds sample application supplied with Access provides an
example. HTH -- -Larry- -- "bikeet2capt" wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
| Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
| Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
| Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
| Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Linear Mode
