I have two fields in a form which are linked to tables forming pull down lists. however these fields relate to each other and I am trying to make it so that if you pick an item from the first list, the second list only lets you choose items that are related to that list eg:-
CADM FRIER
CADM MISC
CADM OVEN
CADM REFRIG
CADM UTENSIL
CIVL BARRIER
CIVL DOOR
CIVL HYD_DOOR
CIVL LIFT
CIVL MISC
CIVL OIL_SKIMMER
CIVL TURNSTILE
CLNR STEAM
CLNR TANK
COMP AIR
COMP AIR_DRY
CRAN BLOCK
CRAN EOT
CRAN FORK_LIFT
CRAN HOIST
CRAN JIB
CRAN MISC
CRAN PORTABLE
CRAN RUNWAY_BEAMS
CRAN TOWER
CRAN TROLLEY
DOCK CAPSTAN
DOCK FAIRLEAD
DOCK MISC
So if I chose CADM in the first list I would only be able to pick either FRIER, MISC, OVEN, REFRIG or UTENSIL from the second list.
At the moment you can pick any from list one and any from list two?
Any help would be great.
CADM FRIER
CADM MISC
CADM OVEN
CADM REFRIG
CADM UTENSIL
CIVL BARRIER
CIVL DOOR
CIVL HYD_DOOR
CIVL LIFT
CIVL MISC
CIVL OIL_SKIMMER
CIVL TURNSTILE
CLNR STEAM
CLNR TANK
COMP AIR
COMP AIR_DRY
CRAN BLOCK
CRAN EOT
CRAN FORK_LIFT
CRAN HOIST
CRAN JIB
CRAN MISC
CRAN PORTABLE
CRAN RUNWAY_BEAMS
CRAN TOWER
CRAN TROLLEY
DOCK CAPSTAN
DOCK FAIRLEAD
DOCK MISC
So if I chose CADM in the first list I would only be able to pick either FRIER, MISC, OVEN, REFRIG or UTENSIL from the second list.
At the moment you can pick any from list one and any from list two?
