How to link a query to a table?

[Tyskie19]

For instance. There is a default selling price, but under circumstances a discount may be applied. So in a query I have set up an expression for this. However, I can't figure out how to link the query to the table so that the new discounted selling price will formulate everytime I enter a new order. How do I do this?

Thanks.

 

[willir]

Tyskie19

You should do this at the form level, not at the table level.

At the form level, you can use EventProcedures to perform this task.

An example would be during your OrderEntry process, you are placing an order for a customer. After selecting the product, the AfterUpdate event procedure checks to see if there is a special price for the customer * product. Then, for the AfterUpdate event procedure for order quantity, you check to see if there is a price break on the order quantity. Finally, the AfterUpdate for the record checks to see if the total sale exceeds a set amount that sets off another price break.

Richard