Reference/dereference conundrum. My data-en...

[Charlie_Wells]

Reference/dereference conundrum.

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.