Let’s say you have 2 tables within a single base: Department and People. Next, pretend you create a single new record in the Department table and link 3 People records: Alice, Bob, and Chris. So the “People” column in the Department table contains the record links and we “Allow linking to multiple records” option enabled. This column also records the order of the People records linked, where the records are positioned in the order of: Alice (first), Bob (second), Chris (third). Next, I’d like to create a VIEW in the People table that shows this corresponding position for these people for this Department. That way, if someone re-orders the linked People to be (hypothetically): Bob (first), Alice (second), and Chris (third) – then this VIEW in the People table would automatically re-order those records, accordingly. The problem is that I don’t think there’s a way to expose Linked Record positional information automatically through any sort of Lookup.
... View more