Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
9 years ago

Repeating conditional lookup on a form

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's avatar
    ChrisChris
    Qrew Assistant Captain
    9 years ago

    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?

    • ZintJoseph's avatar
      ZintJoseph
      Qrew Captain
      9 years ago

      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.



  • ZintJoseph's avatar
    ZintJoseph
    Qrew Captain
    9 years ago

    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