Related SelectWdg

[dankitchen]

Yes correct, that's what I am trying to setup, here is a example of what I am thinking

I have would have 2 tables like building and floor. so I have:

Building A
-floor 1
-floor 2
Building B
-floor 1
-floor 2

so if I have one select looking up buildings and one looking up floors, without the update, the floor select would show:

floor1
floor2
floor1
floor2

So I want it that if the user selects say building A, the floor select would only show:

floor1
floor2

I guess another note is that I don't necessarily have to do this in the table as I will have a custom edit form but...good if it could work in the table as well.

thanks!