I've created two layouts for an invoice table which is part of a larger relational database. One layout is for the data input named 'Invoices' and the second layout is the actual printable invoice named 'Create Invoice'. What I have been trying to do is to create a button that I could use on the first layout which allows me to search for the one invoice related to the current record. At the moment when I go into the second layout it has obviously created all the invoices for the database and I would then do a find. I was hoping to neaten the process with a button script. Is there a simple script that I could use for this?
Thanks in advance,