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.