I'm creating my first DB, I have 2 tables one called Clients and the other one called Invoices.
I made a relation from Clients.ClientID to Invoices.ClientID.
Then in the layout I made a portal to show all invoices for each client and being able to add more and edit them. It works fine.
The problem is I want to have a serial number in each invoice made of 3 parts ClientID-InvoiceNumber-Year (being Invoice number the number of invoices for the current client and not the total number of invoices)
I also would like to be able to show a number next to every invoice showing the invoice number for the current client. Just like this:
Client 1
Client Data....
Invoices:
1: Invoice1
2: Invoice2
...
Client 2
Client Data....
Invoices:
1: Invoice1
2: Invoice2
(Invoice1 and 2 in Client1 are not the same as Invoice1 and 2 in Client2)
Does all this make sense?
