1 Reply Latest reply on Dec 5, 2011 10:52 AM by philmodjunk

    Copy Information From another Field

    ZoocMan85

      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 ?