AnsweredAssumed Answered

Copy Information From another Field

Question asked by ZoocMan85 on Dec 3, 2011
Latest reply on Dec 5, 2011 by philmodjunk

Title

Copy Information From another Field

Post

 Hey everyone,

 

  I have two databases that are linked . One Database has a primary key of the CustomerID and the other database has a forign key as the customer ID and a Primary Key as Invoice ID. What im trying to accomplish is. From my customer Information section...you click on an icon that takes you to an invoice. If i type in the customer ID in manually,  all the information from the customer information section populates all my Inovice fields however i need help on a script. When the user clicks on the button to generate a new invoice.. i want the script to pull the information from CustomerInformation:__PKCustomerID and insert it into Invoice:__FKCustomerID. This why you dont have to manually type in the customer ID. How do i do this ?

Outcomes