fetch data from multiple tables

[ADAJALAN]

Hi,
I'm developing an appsheet, and currently there is a problem where I have 3 tables.

1 transaction table and 2 other tables are reference tables,

in the transaction table there is 1 enum column, where this column takes data from 2 tables as reference.

how can i make the formula on valid if ?
if only one table maybe easy Select(Table_Name,[Column Name],true)

but what about 2 tables?

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/4575684-list-addition

https://help.appsheet.com/en/articles/961274-list-expressions

[ADAJALAN]

Thanks, its works

Select(INVOICING[INVOICE ID],
and([NAMA PERUSAHAAN]=[_THISROW].[NAMA PERUSAHAAN],[REMARK]="Belum Lunas"))
+
Select(PURCHASING[BILL ID],
and([NAMA PERUSAHAAN]=[_THISROW].[NAMA PERUSAHAAN],[REMARK]="Belum Lunas"))

[WillowMobileSys]

Ultimately, the choice in the dropdown list can only come from a single table.  But as you point out, you may need to use criteria from multiple tables to decide which choice are shown in the dropdown.  There are a few ways this is done. 

Instead of giving you confusing psuedo-solutions, could you provide more context about how you need to select values for your dropdown list?