wow dwain.c thanks exactly what I wanted sql server is so strong and both of you 🙂

I'm learning sql server and I'm trying to convert access back-end to sql back-end

My business is fairly simple all products are taxable.

But you are probably right, my structure is not the best, probably with an order on tax instead of hierarchies. l just don't know the exatcly logicial on tax on Canada.

I have federal tax and provincial tax. provincial tax is calculated on (total +federal tax) but what's happen if a 3rd tax come out ???

thanks all ! and next time l'll do a better structure !! because l'll probably need again later ... and it's so nice to have so good advice 🙂

and sorry for my english...