Seems to me your "list" should be a portal. Either a pair of match fields in your relationship or a portal filter expression in portal set up can limit the records shown in the portal to "finalist" scores.
Hi philmodjunk. Thank you for your reply. I tried the portal functionality out and it worked the way I expected.
I'm still pretty new to databases and relationships, so can you explain in a bit more detail what you mean by a pair of match fields in my relationship? Would that be Judge ID and then an additional field (not sure which one)it?
Doesn't sound like you need it here, but if you defined a calculation field in the Judges table, with a number result type and this expression:
You can then set up a relationship to a new table occurrence of scores like this:
Judges::Judge ID = Scores|Finalists::Judge ID AND
Judges::constOne = Scores|Finalists::Finalist
A "table occurrence" BTW, is what we call a "box" on your relationships graph. You can create more than one such occurrence that refers to the same table so if you select Scores and click the duplicate button (two plus signs) you get a new occurrence that refers to the same Scores table so that you can set up a different relationship to it than your original Judges to Scores relationship.
It's important to keep in mind that while you frequently have layouts, tables and table occurrences with exactly the same name, they are not the same thing.