I have two imported tables/lists from an external DB,
One for companies and another for contacts. Companies can have multiple contact persons, they are related by company ID.
In an instantiation form, I would like to be able to select a company from a list (this is working already), and then only allow the user to choose from the contacts (in a separate list field) that relate to the company.
I feel like this should be as simple as a js asset but can't seem to implement one correctly (I'm beginner). Any help and advice appreciated.