AnsweredAssumed Answered

Copy Information From another Field

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


Copy Information From another Field


 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 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 ?