Hi, I am trying to create a simple app but most likely I think in the ”excel” way and not the ”coda” way and therefore I am not able to get this to work. I am new to coda so bare with me…
I have three tables where the main one handels transactions. For each transaction I have to select a company which is in another table. This I have solved and I have a dropdown in the first column of the transaction table that allows me to select the company.
In the second column of the transaction table I would like to be able to select only the types of transactions that are applicable for that company. I have a third table which has a the name of the company in the first column and the transaction type in the second. A company can have multiple entries in this table.
In ”pseudo code” I would like to:
SELECT investment_type from tbl_transaction_types WHERE company = ”tbl_transactions.company”
Looked at the recipe example but that does not create a dropdown, only lists the ingredients with a comma inbetween.