From my research, I think the answer to this question is, "it can't be done", but I'm hoping I'm missing something.My base has 3 tables:Waiting List - this is the "main" table, listing the people on the waiting list.Events - defines the events for wh...
I have a base used for tracking waiting lists for multiple events. A simplified version of the base for purposes of this question is here. Each record is one person’s entry on a waiting list for a specific event. Each record has a Status that starts ...
@gsteinbrecher wrote:If I follow you correctly, you only want a specific list of New York locations able to be selected with New York events, and vice versa with Los Angeles.Well, sort of. The New York and Los Angeles events were just examples to ill...
Thanks @kuovonne. Changing the “All IDs” field from a Lookup to a Rollup and including the formula in it does eliminate an extra field to clean it up a bit.
@ScottWorld Thanks, but I can’t take much credit for it. @kuovonne pointed me in the right direction and then I found a post where she’d offered a solution to a similar problem. :slightly_smiling_face:
Thanks for the hint. Using that and this post, which you also answered, I came up with a solution that works, as shown in my example base:
Create a separate table, called Events.Convert the Event Name field in the Waiting List table to a Link to Even...
