I have on my customer master, a field for credit limit. The user can input
the credit limit for that particular customer. When the user then goes in to
the order screen, in the line item section, I would like for an message to
come up if they have reached their credit limit. So I know I would have to
compare the order quantity against the credit limit. Would I do this in a
query? Do I need to create a different type of query instead of a standard
one? So I would want to see:

Customer Credit Limit Qty Ordered Amt Avail
ACE Hardware 650 20
630
ACE Hardware 60
570

And have it keep it going for every order. Is this possible? What is the
easiest way to do this?

Thanks in advance
Kim P

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1