I am not sure that this solution is functioning correctly as I have problem with the invoice tabel.
I can enter the invoices as they are processed but I need to create a list of all invoices then allow the user to go to a related record.When go to the invoice list table I am unable to retrieve the data on the Invoice table.
I think the rellationships are wrong and not sure where the problem lies.
If anyone is willing to test the other tables and the rellationships it will help a great deal.
A project name and Id is created
A client is assigned tio the project on the same table
Employees are assigned to the project abd tgheir time spent in the project is recored which will create a total cost of the prject.I have not concluded that yet.
The project is invoiced over a period and each invoice number is generated eleshwhere and not in the DB.ie it is entered as an invoice number..