6 Replies Latest reply on Jun 2, 2017 7:25 AM by snazzy78

    Show specific register of a related table




      I have a Filemaker program which has two tables (Company - (1..n) -> Workers). Workers is the related table.


      In a form where show all data of the company. However, I want to show ONLY one register of the workers (for example, the role of project manager who can be ONLY one the workers of that company).


      I have another form where Workers are maintained. There, the field 'Project Manager' specify who is the MANAGER (the ONLY one of that company). You can change it wherever you want, but once is changed, it will be shown in the Form of the company.


      Anybody can help me? How can I do that? I show the pseudo-code in the first form:


      SELECT * FROM Workers

      WHERE CompanyId = {Company.Id}

      AND ProjectManager = true