I have three entities/tables. Users, Businesses and Teams. A business can have many teams and team belongs to only a business. A user belongs to team and team can have many users. When updating a user’s profile I want to present them with a dropdown of all businesses first and after they select a business, present another dropdown with all teams for that selected business so they can select one. First question is that do I need to create association from user to just a team or to both a team and a business. And how do I do that in UI. I tried by creating a relationship of user to both a team and a business but cannot figure out how to populate teams dropdown with for the business selected first from another dropdown.
I figured this out by providing continue option on screen where they select a business and on next screen show teams for that saved business. I think I was not applying the filter the right way when displaying teams dropdown.