Solved: How to reference values from two tables in Enum - Page 2

K5 · 05-02-2023 01:18 AM

Hi, guys. I’d like to have some advice from you.

I have 3 tables,

1) Credit card

-Card name

-Debit

2) Bank account

- Account Name

3) Payment
-Payment Method

"Credit card" table has "Debit" column, and its related to "Bank account" table by ref.

I want to set an Enum on the "Payment Method" column of the "Payments" table so that I can select from the values in the "Card Name" column of the "Credit Card" table and the "Account Name" column of the "Bank Account" table.

<What I tried>

As far as I know, APPSHEET does not seem to be able to reference multiple tables.
It also does not seem to be able to concatenate tables.

So I tried to create a new "Payment Method Reference" table and synchronize "Card Name" and "Bank Account" in it, but could not get it to work.
(By setting up Automation, I was able to add rows automatically, but I was not able to reflect the changes/deletions.)

Any ideas you can give us would be appreciated.

Thank you,

TeeSee1

I maybe wrong but if what you want to do is to create a list of values from two tables to show as suggested values on a column in a third table, you can do so by

Credit Card[card Name] + Bank Account[Account Name]

a simple list concatenation.

The values are not "references" because these do not point to the key values of the two tables but simply text values.

View solution in original post