1 Reply Latest reply on Feb 16, 2016 9:58 AM by siplus

    Auto enter calculation based on match field

    p_pohlhammer

      I have two tables Projects (parent) and Project Details (child). the match field in the relationship is the Project_ID serial number. The serial number. I would like to switch between layouts using a script that will add a related record in the Project Detail table when activated. I have examined templates from other FM databases that appear to do this by using an auto entry calculation for the matching serial number in the child table. One formula uses $$_Current_PROJECT_ID.  I'm trying to determine how to modify that formula to match my field names, but don't see any reference to functions using $$_CURRENT. Can anyone describe how to do this?