best ways to store data

[paulevans]

Hi
I am creating a contact management database.

I have set it up and now need to create an invoice section. An invoice needs to be issued every month and is worked out on a percentage of works complete. For example in one job there may be 10 items of work and for 8 of these iems 25% of the work is complete and the other 2 no work has started.
Therefore my invoice needs to be able to calculate 25% of the value of the 8 items and work out a total price to be invoiced. Each time an invoice is created I need to be able to store the invoice value and the percent value of each item complete.
Does any one have any ideas as to a good way of doing this. That is if you can undersatnd what I am asking for. Thanks for any help.

 

[FoFa]

Each invoice would have a line item with the value and percentage complete. That way you can go back and reference each invoice and see what happened. I would guess each line item would pertain to one item of work. That is typically how it is done.

 

[paulevans]

Thanks for that. I was thinking along the same line but it is always reasuring to hear how other people would do things.