4 Replies Latest reply on Dec 20, 2014 5:25 PM by RickWhitelaw

    Assign invoice numbers to clients



      Assign invoice numbers to clients


      hi, i have two tables - clients and invoices.

      Each invoices has an invoice number and I want the database to automatically list these  (and make them links / buttons to said invoices if not a stretch) in the client records.

      So when the data in client name and address matches the data in the invoice name and address the invoice number is pulled and listed in the client database.

      I have made the relationship between invoices (which is the field name in clients) and invoice number in invoices but nothing is happening...