Lookup Table

[Brad]

In my db I have a main table (TblMain) and a lookup table(TblIssue). Where
the TblIssue and TblMain will be related via Issue (and possibly Model and
Type)
TblMain will be setup like the following:
Model Type Issue
List List List
I would like to setup TblIssue like this:
Issue W X Y 1 2 3
Text ON / OFF BUTTONS
This way I can enter in TblIssue the Issue 1 time and select via on / off
buttons the Model (W, X, or Y) and Type (1, 2 or 3). Note the same issue can
be found on different Models and Types.

Ideally, on my form the user would select via list box the Model and Type
then the Issue list box would be restricted to allow only the issues
associated with that Model and Type. Possible? Some examples would be great
as I'm relatively new to Access

 

[hor vannara]

In my db I have a main table (TblMain) and a lookup table(TblIssue). Where
the TblIssue and TblMain will be related via Issue (and possibly Model and
Type)
TblMain will be setup like the following:
Model Type Issue
List List List
I would like to setup TblIssue like this:
Issue W X Y 1 2 3
Text ON / OFF BUTTONS
This way I can enter in TblIssue the Issue 1 time and select via on / off
buttons the Model (W, X, or Y) and Type (1, 2 or 3). Note the same issue
can
be found on different Models and Types.

Ideally, on my form the user would select via list box the Model and Type
then the Issue list box would be restricted to allow only the issues
associated with that Model and Type. Possible? Some examples would be
great
as I'm relatively new to Access