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.