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 ...
Forum Discussion
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?
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.