I was wondering if I could get some help with a scenario:
In the scenario a particular individual could have multiple records linked to them within another table. In the scenario let’s use contracts as an example.
1 individual could have multiple contracts with start and end dates, along with an attachment.
In the “Master” table we can quite easily look up the Start and End Dates based on a MAX(VALUE), but my question is this:
How would I go about linking THAT SPECIFIC contract to the given dates without showing all other contracts?