Hi guys,
I have a Ms Access table which has fields
1. "DiskName"
2. "DiskType" (which is a LookUp field that has Two values "CD","DVD" to
choose from)
3. "Category"(Which is also a LookUp field that has Two values
"Single","Collection" to choose from)
What I need to be done is bellow.
IF (DiskType="CD") THEN
Can enter Only "Single" For Category Field
ELSE IF (DiskType="DVD") THEN
Can enter any of the two values ("Single" or "Collection")
The Equation I used in the Validation Rule field of "Category" field is mentioned bellow.
=IIF(DiskType="CD","Single","Collection")
But the above equation Results in
1. If DiskType is "CD" - You can enter Only value "Single" (Which is correct)
2. but If DiskType is "DVD" - You can enter Only value "Single"
(Which is NOT correct)
Can someone please help with the equation ???
Thank You.
regards,
Deelliiee
I have a Ms Access table which has fields
1. "DiskName"
2. "DiskType" (which is a LookUp field that has Two values "CD","DVD" to
choose from)
3. "Category"(Which is also a LookUp field that has Two values
"Single","Collection" to choose from)
What I need to be done is bellow.
IF (DiskType="CD") THEN
Can enter Only "Single" For Category Field
ELSE IF (DiskType="DVD") THEN
Can enter any of the two values ("Single" or "Collection")
The Equation I used in the Validation Rule field of "Category" field is mentioned bellow.
=IIF(DiskType="CD","Single","Collection")
But the above equation Results in
1. If DiskType is "CD" - You can enter Only value "Single" (Which is correct)
2. but If DiskType is "DVD" - You can enter Only value "Single"
(Which is NOT correct)
Can someone please help with the equation ???
Thank You.
regards,
Deelliiee