Feature Request - Indirect

Suggestion Box
2

I would appreciate this feature. But the power of indirect isn’t just for dynamically choosing the column name, but also the table name.

This would allow a table column to reference data from not just a fixed table, but dynamically choose the table based on another column.

This allows much more flexibility in the data model space.

Example

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

See [How to dynamically choose table to lookup from?](http://How to dynamically choose table to lookup from? )

-Mark