what seems complicated to me is that i would need to assing each item, a discountype and typeofshipment.
stockid discountype typeofshipment
2323 1 1
2323 1 2
2323 2 1
2323 2 2
therefore, this would create a final price based upon the discounttype, the baseprice (coming from another table), the type fo shipment ( local or national ).
i hope this explanation is clear.
I dont know how to make the program be abe to look and pick the right item with the right set fo conditions. (for the final price)
Thank you for your post.
Yes, you may want to put each possible discounttype and typeofshipment in a separate table. This way, the information could be looked up directly instead of having to calculate each possibility.
In your transaction table, include the discounttype and typeofshipment fields. The relationship into your lookup file would be based upon stockid, discounttype and typeofshipment, or you could set up a lookup into stockid and discounttype, along with lookup into a second table occurrence based upon stockid and typeofshipment.