AnsweredAssumed Answered

Assign invoice numbers to clients

Question asked by AndrewJudd on Dec 20, 2014
Latest reply on Dec 20, 2014 by RickWhitelaw


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