I'm trying to create a layout (Cine1 - Add Tools) where users can click on a listing (Cine1 - Pic Equipment) that will pop up and will insert the just the primary key into the original table (Add Tools) based on the record the user clicks in the listing (Equipment). Currently I have a script connected to a button on the Add Tools layout but I can't get it to work exactly right. It will add new records (cool) but it won't insert the primary key from Cine1 - Pic Equipment into Field in Cine1 - Add Tools.
All this does is adds a new record to Cine1 - Add Tools with a new primary key, the Primary key from Cine1 - Pic Equipment isn't inserted into the field "Job Equipment:Item#" on the "Add Tools.." Layout
I took the script from one Phil had written a while back, but I must have missed a step because the people he helped were happy so it's obvious I've dropped something.
Any advice would be appreciated immensely.