Repeating conditional lookup on a form

Question

I have a form that I am trying to do multiple lookups on a form from the same source table

I have a form that has six individual items that I need to make an entry on

The process would be this

Select a refrigerant from the master refrigerant table...this table has a refrigerant list, a series of pressures and temperatures in three columns
Enter a pressure for each piece of equipment
This pressure entry needs to do a pressure to corresponding temperature lookup
The tech then enters a temperature reading and this does a calculation in another field to subtract the converted pressure to temperature from the temperature reading

Example attached.

I am thinking I need to split my Refrigerant PT Chart into multiple tables so that I can setup (6) individual lookups...

Thanks in advance for any help possible

ChrisChris · Answer

The SPTP fields are also mathematically derived, yes? When you make the Suction Pressure fields selectable then tab away, the SpTp formula math field will populate. Am I tracking with you correctly?

Sign up

Login to the community