Karen,
I am very unfamiliar with using listviews. I have some working but for some reason I have problems with getting the On Click EEPs to work. Maybe someone can help me understand how the LISTVIEWS work. I name the listview vPartChoice. The primary field is Partnum and the table is Inv_all_open. Does the listview (vPartChoice) take on the value of Partnum? If not then how do I associate to the Partnum field within the Listview (the one that my cursor is on)? If I need to learn the Property or the Get Property commands, then I want to do that. Jim I have looked on the examples in RRBYW14 and have copied them to my system, adapted them and some work. I still need to understand why they work! Jim A lot to learn. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, August 21, 2009 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CALCULATIONS WITH VARIABLE LISTVIEW Jim: The following line is invalid syntax. EDIT USING KPRAssyPartGrid WHERE Assembly# = (SELECT Partnum FROM .vPartchoice) ORDER BY Assembly# The problem is what's in your parenthesis. Don't know what your tablename is, but it should be something like this: (SELECT assembly# FROM yourtablename WHERE partnum = .vpartchoice) Are you comparing Assembly# in one table to the same column name in the other table? And the "order by assembly#" seems superfluous since your "edit using" is only going to return one single assembly#. Karen 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
