I have setup a custom profile page for my members that is connected to a database. It allows me to select “Reference” my other dataset which has all my department names in it. Thats great - but what I want to be able to do now is allow a “Sub-Reference” or “Sub-Category” to allow members to then also choose their title within that department.
How can I do this?
Can you better explain what you need?
I think using pictures will make it easier to explain. this is my custom user form for member.
Right now box 2 is connected to a dataset (categories) containing the names of each department.
I want box 3, to show different results depending on what the user chooses for box 2 (department)
Does that help?
How do look like your second COLLECTION (categories) ?
I think I got the idea:
You want the JOB TITLE dropdown to change and show the job title referenced in another COLLECTION, filtered by the DEPARTMENT dropdown.
Can you show us the other COLLECTION?
