I have a
Customer Table containing info such as Customer # (Number), Name(Single line of text), Bankruptcy status (Yes/No), Currency (Choice).
I also have a
Invoice table which has a lookup column for the Customer #, pulling in the Customer Name.
Now, the scope of the project has made it so I need to pull in the Currency column using the Customer # lookup, which seems like it would've been straight forward; however, I don't see any of the other columns besides the system generated ones (Version, Title, ID, Created, etc.)
How can I get the lookup column to also include the currency in the