Tables / Lookup Tables

  • Thread starter Thread starter Jeannette
  • Start date Start date
J

Jeannette

I am creating a database in Access '97. I have a main
table and a lot of look up tables. However, on one of my
look up tables, their are three choices to select from. I
do not know how to do this. I have created look up tables
many times but never had a situation that the look up
table breaks down further.

For instance on the look up table you would select one of
the choices below....

Code Key
1 BC Open
2 BC Issues
3 Sales Open
4 Updates Required........Y, N, S

However for #4 you would select on of the 3 choices below.
Y = BC Issue
N = No
S = Yes Sales Issue

Hope this makes sense. Please help!!!
Thank you.
 
Code Key
1 BC Open
2 BC Issues
3 Sales Open
4 Updates Required........Y, N, S
Click to expand...

what's wrong with

Code Key
1 BC Open
2 BC Issues
3 Sales Open
Y Updates Required........Y
N Updates Required........N
S Updates Required........S


B Wishes


Tim F
 
Back
Top