Re: Linking Forms in Developer 2000

If what you mean by it doesnt work is that it doesn't compile then that is because your new (2nd) form does not have access to :PlaceOrder which is in the first form.

To pass the ProductId from the first form to the second form use a form parameter, use something like this:

Form 1
 open_form( "2ndForm", activate, session, ..., "ProductId= :Product.ProductId");

Form 2
 where ProductId= :PARAMETER.ProductId;
 --
Elias Asfaw-Kirby
elias_at_icpsr.umich.ed
734-998-9852

"Tommi" <Tommi.Pekonen_at_btopenworld.com> wrote in message news:193ddfe7.0202220803.5bddb07c_at_posting.google.com...
> Hi,
> Please help me with the following:
> I am trying to link 2 separate forms so that when I query the first
> one and then click a button to (open_form) open the second, I would
> have the same record open in the 2nd form as in 1st.
> I have created WHEN-NEW-FORM-INSTANCE trigger:
> select ProductTitle, ProductId
> into :Book.ProductTitle, :Book.ProductId
> from Product
> where ProductId=:PlaceOrder.Product.ProductId;
> end;
> But the where clause does not work!
> Please help. Many thanks,
> Tommi
Received on Mon Feb 25 2002 - 21:34:34 CET