AnsweredAssumed Answered

Embedding a calculated field name into a lookup function

Question asked by trialuser1111 on Oct 5, 2009
Latest reply on Oct 8, 2009 by trialuser1111

Title

Embedding a calculated field name into a lookup function

Post

I need help using a lookup function within another lookup function, where the "inner" lookup is used to identify the field name for the "outer" lookup.

 

I want to be able to lookup the market sector ownership of a company and have that market sector change dynamically based on which client the report is for.  I tried the following calculation and FileMaker wouldn't allow it:

 

Lookup ( Analytics::Lookup ( Market Data 3::Mkt Sector ) )

 

Is there a way to get a function like this to work?  The "inner" lookup (to identify the sector) matches the the field name in the Analytics table exactly by design, so I know that's not the problem.  If I used a script and some variable I suppose that would get me the right result, but I'm trying to avoid scripts here because I plan to use this relationship/solution in multiple forms throughout the database.

 

Thanks 

Outcomes