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
