Hi all -
I have three tables (Riders, Horses, Results). I have created portals in layouts under Riders and Horses that show the data from Results with no problem. Now I want to create a portal in a layout under Riders that gives a summary by each horse that the rider rode.
In my Results table, each record has the riderID and horseID. I have a relationship from the Results to Riders based on riderID and from Results to Horses based on horseID.
I can't figure out how to create a portal in a layout for my Riders that pulls all their results from the Results table and then shows a summary of data by Horse. What am I missing?