Use value in field defined by calculation

[filmo]

Hi,

In one database, I have our current price list for each product defined as a global. For example, the field "S30" contains the price for a "Standard 30 minute Interview"; "S60" for a 60 minute, etc.

In the second database, new jobs are logged and tracked. I've already created the calculation based on the length and type of interview which give me a text result like "S30", or "S60", etc.

What I want to be able to do is then create an InterviewPrice field which looks up the value in the price sheet as defined by its name. In this case, the calculation of "S30" would look inside the price sheet database and lookup the value contained in the global called "S30".

If it makes it easier, I would be willing to move the global price definitions into the same database as the log and tracking database, but would like to keep them together.

Any help or suggestions would be appreciated.

Thanks, Phil Glau

[LiveOak]

I'm lost. How about listing the files by name, giving the important fields and their types in each, and then restating your desired result? -bd