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

    Assign invoice numbers to clients

    AndrewJudd

      Title

      Assign invoice numbers to clients

      Post

      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...

      Screen_Shot_2014-12-20_at_21.54.57.png