How to dynamically choose table to lookup from?

[Mark_Sluser]

If I have 3 tables:

table_car
ID, Desc
1, Honda Civic
2, Nissan Rogue

table_house
1,123 Newport Road
2, 457 Glenwood Street

table_owns
ID, person, thing_type, thing
1, Steve, table_car, Honda Civic
2, Victor, table_house, 457 Glenwood Street

How can I choose between the table_car and table_house in table_owns?

I have seen other posts similar but the solutions don’t meet my needs:

Can you do a conditional selection from one table to another?

Im trying to make a master list of items where I want to choose and add only certain items to another table. Do anyone know if thats possible?

Thank you,

-Mark

[Mark_Sluser]

Suggestion at

Lookup from multiple tables

Hi I have a few tables that list a number of services/products. I would love to put all the services/products into one table but each service/product has different requirements and therefor different columns. I am trying to build a table that will help me price up jobs. I would like to use a dropdown list to take services/products from different tables which will add the cost based on the selection, I’ll then continue to add a row for each service and finally calculate the price. I can do thi…

would make a solution
thing column’s selection property = Switch(thisRow.Type,"table_car",table_car.Desc,"table_house",table_house.Desc)

This somewhat works, but for every choice added to the list of tables to choose from, you need to modify the selection string in the thing column’s selection property.

Excel uses the indirect function for these kinds of situations.

Anything like that in Coda ?

-Mark