I assume a list view is just that, a view of what is in a table with no capability to change anything. I do not want to change anything in the view I am looking at but I would like to make calculations on some of the information in a listview. Here is what I want to accomplish:
1) I want to get the parts that ship when a model is shipped. (I.E. (1) body & (4) legs would make up one model). 2) I want to multiple the number of parts by the number of units on order and get a result. This would have to be done for each part making up a model that was ordered. This way the sales people can not only see the number of units on order but also see the parts inventory of what makes up the model. I hope I am being clear enough. 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
