Tables / Lookup Tables

[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.

 

[Tim Ferguson]

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

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