Repeating conditional lookup on a form

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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


Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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?

Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

There is a correlation between a refrigerant pressure and temperature so the SPTP field is a lookup of the temp associated to a pressure state.



Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Thanks for those that are taking a look at this...I had someone push me in the right direction and it is working now...select the pressure, the SpTp temp is populated, enter the STemp and the SupHt is calculation