I have to do this for my boss,but have no idea where to start.

I need to build a packing list, and here is what i want to do.

If we are sending 100 shirts, but can only fix 60 in every carton. how can i make it so that all i have to put is the Qty per carton, and the Qty that im shipping and the item number and have the program do the math.

I want to able to see box 1 with 60 shirts for item number ASM001, and have box 2 with 40 shirts for item number ASM001. ANy Ideas.

Just make a table called "stock" or some such... in there put all your items, the prices per shirt im assuming for each item and the max number of shirts per box that ll fit...

i.e. Product ID

Price (per item)

Max Items Per Box

Then im going to assume that you order by a client (and already have a basic table set up with this like client id etc.) and have a portal set up so you can add new orders etc.

Then you have another table called "order"

This is your related table for the purpose of ordering through a portal (this is related to the stock table by Product ID value)...

So, we have

Client ID (auto entered from last visited record)

Product ID

No. Items

No. Boxes (Calculation with result:

(Ceiling (No. Items / Max Items Per Box ) * Max Items Per Box) / Max Items Per Box) [[This section basically rounds up your items to the max number thatll fit in a box for that item and then divides that number by the max to get you your number of boxes]]

Total Price (Calculation with result (No. Items * stock::Price (per item)).

hope this helped and or made some sense...

Edited September 29, 200520 yr by Guest