G
Guest
OK, so I am designing a database...This may be a no brainer or difficult...
I want a lookup column with 4 options, then I want a 2nd lookup column based
on the previous answer.
For example...if in 1st lookup they have the option of choosing A, B, C or D
and they select A, then the 2nd lookup B only allows them to select 1, 2or 3
But if they select B in the 1st lookup, the 2nd lookup allows them to select
4, 5 or 6...so and so on...
does that make sense... I Hope so...
I want a lookup column with 4 options, then I want a 2nd lookup column based
on the previous answer.
For example...if in 1st lookup they have the option of choosing A, B, C or D
and they select A, then the 2nd lookup B only allows them to select 1, 2or 3
But if they select B in the 1st lookup, the 2nd lookup allows them to select
4, 5 or 6...so and so on...
does that make sense... I Hope so...