You have a client database. The clients are static and have a unique ID number that is entered or automatically entered.
You have invoices. A client can have multiple invoices. Each invoice has a unique InvID number that is entered or automatically entered.
The ClientID is related to InvoiceClientID and is entered manually.
Do the invoices contain InvoiceLineItems that can be one or two or many. If so, then that is another Table or Database. The InvoiceLineItems would have a unique ID number related to InvoiceIDNumber.
What is true about the above assumptions?
First of all thanks a lot!
Yes I have created my client database with automatic id number.
Yes I have created invoice and client can have multiple invoices and each with unique automatically entered number.
I cannot o have not been able to relate the client id to the invoice client id.
The invoice can have manyinvoice line item that I must as well link to the productlisting database.