Copy Information From another Field
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 ?
Set Variable [$CustID ; value: CustomerInformation::__PKCustomerID]
go To layout [invoices]
Set Field [Invoice:__FKCustomerID ; $CustID ]