Delivery Charges

[Simon]

I have a access databse that i use for my online shop. Currently for
the delivery chage i have entered the different delivery costs into my
product table and then add them as a line in my subform on my order.


Is there a better way to do deliveyr cost. if any one could tell me
that will be great

Thanks

 

[JK]

Simon,

It is a matter of "horses for courses".

If you have a few standard delivery charges, *not* related to what you are
actually shipping, your approach is fine - I assume that have set up in the
products table, some "products" called delivery.

If on the other hand the delivery charges do depending on the products you
are shipping, (Delivery charge fro product A = X and delivery charge for
Product B=Y etc), those charges should be stored in separate field in your
Product table with a value against each product. If you still want to show
only the total of the delivery, run a sum on the delivery costs when you
generate the invoice.

From your brief description (online shop) I doubt that you would need
anything more elaborate that would require a delivery charges table that
looks at number of factors to determine the charge as is a case in ocean or
air freight.

Regards/JK