AnsweredAssumed Answered

Setting a field value

Question asked by colinmatthews on Feb 21, 2014
Latest reply on Feb 22, 2014 by 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,