Jan,
I was thinking along the same line. I could do this by creating a temp table, updating it with the calculated info and then that table would show up on the second form (the first form would be a simple two field form just for the model & quantity). Next I want to have the option for the user to click on the listview row that contains an assembly so they can see the parts that make up the assembly. I have RDOCs but I still am not sure how to use all functions. This listview is called vPartChoice that is based on a table INV_ALL_OPEN. The primary field is Partnum. On right click the EEP states: SET VAR VFormMode = 'EDIT' EDIT USING KPRAssyPartGrid WHERE Assembly# = (SELECT Partnum FROM .vPartchoice) + ORDER BY Assembly# RETURN I get a syntax error. When I check my variables, I see this: RBTI_FORM_COMPID = PartChoice_Comp TEXT RBTI_FORM_DIRTYVAR = 0 INTEGER RBTI_FORM_VARNAME = vPartChoice TEXT RBTI_FORM_VARVALUE = J2-SA1 TEXT The J2-SA1 is the partnum I was right clicking on so I am close. What might I be doing wrong? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, August 21, 2009 8:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CALCULATIONS WITH VARIABLE LISTVIEW Jim, You state that you know how to do it in a report. One way is to place the calculations that you know and place them in a bit button. So once your user has entered the model and qty then calculate and display the results. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 20 Aug 2009 16:50:44 -0500 Subject: [RBASE-L] - CALCULATIONS WITH VARIABLE LISTVIEW I have successfully implemented two Variable Listviews on a form. These listviews show the parts that ship for any particular Model we sell. The left lilstview vChoice has the parts with quantity that ship for a single model. The right listview vPartChoice shows the parts needed to fill all open orders for each part for that model as well as the total parts in inventory for each part What I want to do now is make it so the sales person can fill out the Model number and the quantity a customer wants, have calculations that will show the total quantity needed for each part in that model. Then I want to take those quantities and subtract them from the actual pieces in inventory. Any Ideas how to do this in a listview. ( I know how to accomplish this in a report but unfamiliar with forms) Jim
