Copying and Pasting info from one database into another using a script and a button
i have two databases (enter_data and Purchase Orders). i want to click a button in the enter_data database and have it copy the info in one field (style Name) then go to the other data base (Purchase Orders) and paste it in the next field (Product description), hit return to go into the next field and then return to original database (enter_data).
ive tried doing this using a script but i feel that i have the relationships wrong or something.
anyone have any idea how to do this easily?
thanks for your help
(im including a screenshot of script i started)