I would like to achieve something that seems basic but i can’t find a solution.
I have a table of contacts, another table of companies and of third one of projets.
I link a contact to a company and a company to a specific project. I have several contacts for each company and i would like to link a project to a specific contact. I obviously can link the project to a contacts but i would like to only be able to select someone from the company in charge of the project. At this point i can pic any contact. I know that we can make a condition on a specific view but the view as to be “dynamic”. I don’t want to manually create a view for each company.
Thanks for your healp!