get data from a table not in a query

Hi all.
I have the following issue:

I have a query with the following tables: WCust, WFees, and RateType. The
WCust contains customer name, address, etc., WFees contains vaious fees paid,
and RateType contains 3 different rate types and the rates specific to each
type. The RateType table stores rates for retail customers. If type "B" then
20rate = .75 and if type "T" then 20rate = 1.25. My issue is that the
wholesale customer sells to both types "B" and "T". So when using a form
called WCustFees and entering total cartons sold to type "B" customers it
needs to calc the rate using .75 and like wise with "T" customers it needs to
calc the rate using 1.25. Does anyone have any suggestions as to how to
handle this.

Polly

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1