I have never understood this, in the last data base I manage to get it working by creating way to many fields.
I have something very similar to an invoicing set up in my database, but it's for tracking time.
I want to be able to look back at the month so far and see at a glance how much time I have spent on each client. and I would like to display it in a pie chart.
Client A X hours
Client B Y hours
Client C Z hours...
Pie Chart here!
I assume I use the table lines for this, what fields do I need? and how do then create the pie chart?