Sounds like you just need to store a person ID in the Scores table, alongside the Sweep ID.
Then in the Sweeps table, make a multi relation to return all people in a Sweep, and have a joined list column to return a comma-delimited string of person IDs.
In your choice component, point to the list of all people, filter by rowID is not included in screen > comma-delimited string above.
I donât have specific ROW ID columns. I assume this method wonât work unless these are created?
Itâs always best to use RowIDs for this sort of thing, as they are guaranteed to be unique.
The fields I was referencing have unique data but theyâre not appearing when I try to add a filter to the choice component.
Thatâs why I asked. I thought perhaps a row ID had different characteristics that allowed it to be seen across multiple components.
It took a while but your suggestion worked. Thank you.
Itâs okay. I figured it out.
Looking at the table below, I am trying to create a column that will tell me which scores have been used on which date. I created a relation field where date is mapped to Scores-Placing but thatâs not giving me anything. How can I create a column that will show me every placing used on the same date?
Is the table above supposed to store âscoresâ as well? Iâm not sure what you mean by âcreated a relation field where date is mapped to Scores-Placing but thatâs not giving me anythingâ (arenât those different types of data?)
