Re: [Openinteract-help] CommonHandler Master-Detail Solution ?

[Chris W. <ch...@cw...>]

On Tue, 2002-02-12 at 07:21, Tho...@be... wrote:
> I've some questions, how to realise a master-detail solution with the
> CommonHandler.
> 
> I've got a normal CommenHandler application, with search, edit and so on ...
> 
> Now I want to Link the table of this apllikation with another table.
> 
> For instance: Searching for an IP-number , CommonHandler looks for this IP
> in the main table, ok ... now CommonHandler should look for further
> information matching to this IP number in the other table and display all
> information in the default listing view.
> 
> How can I realise this the best way ?

Using the MY_SEARCH_TABLE_LINKS option, CommonHandler will create JOIN
statements for you. As with any automated SQL-generation the setup is a
little tricky. See the POD for both MY_SEARCH_TABLE_LINKS and
MY_SEARCH_FIELDS for examples.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.