AnsweredAssumed Answered

Show one related record out of many

Question asked by mikedorn on Jul 5, 2012
Latest reply on Jul 16, 2012 by philmodjunk

Title

Show one related record out of many

Post

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.

 

Please advise,

Outcomes