I've inherited a FileMaker (version 14) database at work that needs more functionality.
Currently the template uses a Boolean function to populate field labels (gray fields) for specific units of pressure.
Pressure value (white field) is input by user:
Example: 4 Boolean functions include: kg/cm^2, psi, kPa, or bar
Units are stored in the data base based on selection made by the user.
My goal is to be able to perform searches based on one pressure unit (example: psi) and have all records returned that are equal to 400 psi regardless of the input unit.
Any suggestions on how to accomplish this?
Thank you for your time!