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