G
Guest
I have a table that list equipment by number (primary key). Each equipment
is further catagorized by 1 of 4 different types of equipment. On my form I
have 4 combo boxes in different sections of the form, one for each type of
equipment. I want to be able to use the limit to list feature. However,
when I go to the first combo box that list only type1 equipment, if I input
for instance "18" (which doesn't show up in the first combo box because it is
in the table as a type3 equipment), I run into problems. How do I check the
table to be sure I'm using a unique number?
is further catagorized by 1 of 4 different types of equipment. On my form I
have 4 combo boxes in different sections of the form, one for each type of
equipment. I want to be able to use the limit to list feature. However,
when I go to the first combo box that list only type1 equipment, if I input
for instance "18" (which doesn't show up in the first combo box because it is
in the table as a type3 equipment), I run into problems. How do I check the
table to be sure I'm using a unique number?