Copying records from one file to a mother
I have two files, the main Contacts file has the address details etc. The other is a copy of the Start up solutions "Invoices", I want to bring in the contact details (address etc) from the main Contacts file to the new "Invoices" file. I have created a value list that grabs the Company/Organisation name in the "Invoices" file from a Value List (drop-down list) from the Contacts information, but when I select this Company I want to fill in the rest of the address etc details. I don't mind if this is done with a button and script. Just by selecting the name would be better though.