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
>
>
