dear Martijn,

agree, but i choose invoice and items just as a sample....

thanks again
stephane

--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
> >> Many ways to do this 2 are:
> >> 1. I never put the invoice total in. I always retotal the items.
> >
> > I don't think that is a viable option. I think the total needs to be as
> > the transaction was at the time of sale, not as it would if the sale was
> > at the current time (with different prices).
> >
>
> Store the prices with the invoice items, it's easier to give a special
> discount for this invoice only as well.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>