Here’s a little question about the use of Secondary Keys (https://programmerbay.com/difference-between-primary-key-and-secondary-key/).
I’m interested in forming REF relationships based not only on primary keys (which Appsheet currently allows), but also based on a modifiable unique secondary key column set by the user (Appsheet doesn’t allow choosing more than one column as your key column). Has anyone found a computationally lightweight alternative way to do this? I was thinking of a LOOKUP expression but this might be computationally expensive for large tables.
Perhaps related to this: