Combining multiple lookups into one column

Topic Labels: Formulas
912 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am using the program to help me in the production of a play, and thus far its great. I have one thing that I want to do with the program that I have not been able to figure out and I was wondering if anyone had any advice.
A quick background:
I have a “Company” table with casting that includes Actors and Roles.
Two other tables (Songs and Scenes) are linked to “Company” where I select roles which are in either the “Song” or the “Scene”. I also have a Lookup Column on these tables so that my Actors appear in those tables as well.

I would love to build a “Daily Call Table” from this and I was wondering if it is possible to create a Lookup column that can contain values from Actors in all three tables (“Company” “Songs” and “Scenes”). This would enable me to input actors into one column by selecting them individually (“Company”) or by group (“Scene” and “Song”)
Or to create three Lookup columns that I can combine (and then hide the original columns).

Thanks everyone

0 Replies 0