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

    Setting a field value


      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,