Repeating conditional lookup on a form | Discussions

Expand all | Collapse all

Repeating conditional lookup on a form

  • 1.  Repeating conditional lookup on a form

    Bronze
    Contributor
    Posted 03-23-2017 19:38
    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




  • 2.  RE: Repeating conditional lookup on a form

    Silver
    Contributor
    Posted 03-23-2017 20:00

    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?



  • 3.  RE: Repeating conditional lookup on a form

    Bronze
    Contributor
    Posted 03-23-2017 21:12

    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.





  • 4.  RE: Repeating conditional lookup on a form

    Bronze
    Contributor
    Posted 03-23-2017 21:17

    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