Jan,
I actually had it set up originally that way. I just found out that it was working but I just did not realize it. Not knowing how the DBGRID worked, I was only going between rows in the same column. I did not realize I needed to go between columns as well as the rows for the EEP to work. I just did that and it works. Your suggestion prompted me to try again what I had started at first and I accidentally got it. Thanks! Now on to the rest of the process. Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Friday, November 21, 2008 9:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Inventory Jim, Just a guest. Is your first row in the Model# table the value you are seeing? If so base a Variable .vModel# on your MODEL#. Then change your select to SELECT (SUM(Quantity)) INTO vModelTotal INDIC ivModelTotal + FROM Ship_View WHERE Shipdate IS NULL AND Model# = .vModel# Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 21 Nov 2008 08:19:42 -0600 Subject: [RBASE-L] - Inventory Here is what I am trying to accomplish. I want to have a form the will be used by Sales to quickly check on Inventory. This form would do the following: 1) It would show the orders still not shipped 2) It would give the totals on order based on product when you go into that field. 3) It would show the available inventory for that item. 4) (It will do more if I can get this done but that will come later) I started with a DBGRID based on the open orders and that works fine. I have a listview that shows the parts needed to fill a specific order and that is fine. I created a variable vModelTotal whose purpose is to show the number of units needed to fill ALL openorders for that model. I get a number in the variable but it does not change when I go to the next line having a different model. I am not sure how to use the EEP in the DBGRID. Right now the EEP is on Entry into DBGRID column and the EEP states: RECALC VARIABLES SELECT (SUM(Quantity)) INTO vModelTotal INDIC ivModelTotal + FROM Ship_View WHERE Shipdate IS NULL AND Model# = Model# RECALC VARIABLES RETURN This is where I am stumped. Once I get this figured out I will be able to bring in the Inventory amounts for comparison. Any help is appreciated. If anyone thinks I am organizing this wrong, I am open for suggestions. Jim
