Re: Forms query on a non base table item
Date: Fri, 16 Apr 1999 11:43:18 +0300
Message-ID: <3716f7b3$0$8165_at_diablo.uninet.ee>
Pradhan <empradhan_at_dplus.net> wrote in message
news:XUxR2.155$4I2.3214_at_newsfeed.slurp.net...
> Hi
> post_query trigger on block level will do it..
It works fine but you do then two separate query to retrieve one row. The alternate choice is to make a block based on view and transactions go through the tarnsactional triggers.
Iff
> HTH
> pradhan
>
> Bob Hirons wrote in message <3715F801.7CDA5D7_at_hotmail.com>...
> >How do I code a form to allow query on a non base table item?
> >
> >e.g.
> >base table ORDER has-
> >ORD_NO
> >ORD_DESC
> >CUSTOMER_CODE
> >
> >table CUSTOMER has-
> >CUSTOMER_CODE
> >CUSTOMER_NAME
> >
> >form has items
> >ORD_NO base table item
> >ORD_DESC base table item
> >CUSTOMER_CODE base table item
> >CUSTOMER_NAME non base table item
> >
> >Wish to allow query on CUSTOMER_NAME.
> >
> >
>
>
Received on Fri Apr 16 1999 - 10:43:18 CEST