AnsweredAssumed Answered

Creating Invoices from 2 related tables

Question asked by SimonSherwood_1 on Aug 12, 2014
Latest reply on Aug 12, 2014 by SimonSherwood_1

Title

Creating Invoices from 2 related tables

Post

     Hi All

      

     I'm after some pointers on how best to achieve this I don't have a specific query.  I have 2 tables Customers and Transactions.  Customers is populated with information about the customer, it has a form view with a portal to the transactions table where related transactions can be added to the transactions table.

     I want to make a button that will create an invoice, however I don't want all the related records from transaction showing, just the relevant one or two.  I could make a new table called invoices and make a script to populated fields with customer information, no problem but I'm not sure on how to only display the few records I want from the transactions table.

      

     Thanks in advance.

     Simon.

Outcomes