> > No offence, but you created this can of worms yourself.
> >
> > I don't know what the "QTY" field means, but what if the user
> > enters "12 dozen", cause they can?
>
> Heheheh...yeah, I'm just a big softy when it comes to their requests.
>
> I would hope that in that case they'd had the sense to be using a
> price per dozen. Apparently the different suppliers they use quote in
> all sorts of quantities and I want to allow the printed orders to show
> the units they were quoted on. I take your point tho. :)

Wouldn't it be easier to let them enter a quantity and a unit instead
of 1 field with both items? This would also be a better database design,
given that 1 column should store 1 type of values only.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com