I have a database similar to a discussion from 2013 - Filter portal records based on date range.
I have tables Projects and Consultants. They are joined in a third table, projects_consultants
Projects -----< projects_consultants >----- Consultants
A consultant can only work on one project at a time. When creating a project with a start- and end date, I'd like portal to display only consultants who are not assigned to other projects in this timeframe.
I've been playing around with filtered portals, but so far I've only produced a list of already allocated consultants.
FileMaker has evolved since 2013, so I wondered if there were other strategies i can pursue?
I'm on FMP 17.