I'm trying to filter a dropdown based on the value from another dropdown. I have 2 tables:
Table1
name
Table2
name
type
What I would like to do is when the name is selected in Table1 that is filters the types that are available in Table2. I have tried where statments on the Add page for the type field but no luck. Can anyone suggest the best way to filter the 2nd dropdown based on the name?
Any help would be greatly appreciated.
Sarah