Show one related record out of many
My employees have many jobs which have many reviews (usually one per year) but could be more. How do I get a certain related review to show from the many that are in the review table.
Relationships now are:
Employee ID===>Jobs ID
Employee ID===>Review ID
Or should the relationships be:
Employee ID===>Jobs ID===>Review ID
I'm using a Goto Related Record script now, that show every Review for that Employee. I'm after the single related record by the review date.