Hi Igor, >> the Order - Invoice relationship is many-to-many.
> How are you going to break down order delivery charges in this case? Good question. I have been wondering the same. It's a purely auditing/ accounting requirement, to compare the expense and income of a particular invoice. For that purpose, I will probably divide the delivery cost of an order among the invoices that relate to it. So, for instance, if Order 11020 is for two products with delivery of $20, one sent with Invoice 10002, another with Invoice 10003, then I could divide the $20 delivery cost into $10 against each Invoice. I'll have to think some more about that :-/ Thanks, Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
