Re: Forms 4.5: ORDER BY <column in detail_block>

You need to denormalize your data to get it to work in forms.

1. Create a database view and use that as your base table.
2. When you create the form, make the master block based on the interface table (presumably this contains the computer id and the ip address) and the details block based on the computers table. Don't know how this would affect performance but you should at least be able to get it to work.

Bob

Standard disclaimers apply.

>
> Walter Zimmer <see_at_signature.for.email.de> wrote
> > Hi !
> >
> > I have a problem which has - I believe - no solution in Forms 4.5:
> >
> > I have two blocks, one master with computers and one detail with
> > network interfaces. I need this because every computer can have
> > several network interfaces. The detail table contains also the
> > IP-addresses, and now the question arises:
> >
> > How can I query the master block, but ORDER BY according to the
> > IP-address ?
>
Received on Tue Sep 02 1997 - 00:00:00 CEST