Say I have 3 tables; Users, accounts, assets.
A user is completely unique and has a one to many relationship with Accounts.
Accounts has a one to many relationship with Assets.
I want to create a form for adding new assets. The person needs to select which account the asset belongs to. Given multiple users, each with numerous accounts - simply having a full drop down list of all the possible accounts is not feasible.
How do I create a form with a "user" dropdown where the "accounts" dropdown only shows values linked to the selected "user"? Thus filtering the possible accounts to just the ones belonging to a specific user?
I have played with rules but cant seem to find a way.