Tables, several lookup values in different columns in one table

Hello, is it possible to select an item/value from a column in another table with several “list colums” like
3X_0_2_020f9c05f8a19c87fbee182fe11354e8462818ec.png
So when i select type “Booster Panel” in a form it will give me the items (Type numbers) from “booster panel” column to choose from, when I select “duct detector” I get the items under "duct detector "to choose from. “booster panel” and “duct detector” are in the same table as separate columns.

Can someone help, or is this not possible and do I need to setup a table for every Type
Thanks Muk

0 4 336
4 REPLIES 4