I am new to FM and have been trying to work out how I can use the pop up menus or drop down lists to filter options.
Ideally this is what I will have working at the end. with Primary, secondary & tertiary being drop downs and Product name being a standard text box
I want to be able to have PrimaryCat1-9 which will then filter down the secondary categories to only ones related to the Primary and the same for the Tertiary.
I have a basic understanding of relationships and have been able to get this to work with just primary and secondary categories but not when I implement the third.
Any help would be great!
Thanks in advance!