My data-entry table has a Number column defined as Ref. The user enters a number and that number is currently dereferenced with data from a table called Members (to get a member’s name once a number is selected).
So now I need to also use Number to grab data from another read-only table which contains permit information for members. That table is also keyed by Number.
So basically I want [Number] in my data-entry table to reference two other tables.
Is that even doable? Or is the only solution to combine the two read-only tables into one at the back end? (I’m dealing with legacy data, which is why this is a bit messy).
EDIT: Maybe create a virtual column in the data-entry whose value is the number entered elsewhere in the form, and use that as a ref into the second table? Trying that… Thanks.