4 Replies Latest reply on Feb 22, 2014 4:36 AM by colinmatthews

    Setting a field value

    colinmatthews

      Hi all,

       

      I have a Product layout and a Profit Calculation layout. In the Product layout I would like a portal displaying the Profit Calculation for each product.

       

      There are about 50 fields in the Profit Calculation layout (sell in multiple countries so different prices and currenices etc) so I can't simply tick the relationship option 'Allow creation of records in this table via this relationship' and create the record from the portal - I need the user to go to the Profit Calculation layout and add the data there.

       

      What I cannot figure out is how to automatically populate the FKProfitCalculation field with the PKProduct field so that the two records are related.

       

      I have tried the 'Set Field' script but this isn't working and I have had the two records auto-increment from the same value which works but is potentially open to errors (records fall out of sync).

       

      Any help would be greatly appreciated.

       

      Many thanks,

       

      Colin