Pulling data from one record to another

Discussion created by colinmatthews on Feb 18, 2014
Latest reply on Mar 2, 2014 by mikebeargie

Hi all,


I have a layout for Product Sourcing where I track products, quotes, suppliers, lead times etc. From the records created we may proceed with just one supplier in ten. In this layout I detail each supplier's details.


I would like a separate layout specifically for suppliers that we engage with so ideally I could have a button on the Product Souring layout (Create Supplier, for example) which then creates a record in the Supplier layout and pulls through the relevant details from the Product Sourcing record.


I have tried the following and have come to a dead end:


1. In the Supplier layout I have set each field to display data from the relevant fields in the Product Sourcing layout.

2. Added a button to Product Sourcing with the script: New Window; Go to layout [Suppliers]; New Record/Request; Close Window


I can see that I need to relate the PK and FK IDs from the two tables but can't figure out how to do that in the scripting. Can anyone help me out?


Or, is there a better way of doing this?


Many thanks,