Re: how to implement Many-to-Many relationship in Forms 4.5?

You must use intersection table I think.

Phil Lee wrote:
>
> Hi,
>
> Does anyone know how to implement a Many-to-Many relationship in
> Forms 4.5 or Forms 5.0?
>
> Here are the tables for the Many-to-Many relationship:
>
> PEOPLE
> ______
> # person_id
> first_name
> last_name
> title
> organization
> addr
> city
>
> EXHIBITORS
> ----------
> # exhibitor_id
> exhibitor_name
> description
> exhibitor_type
> comments
>
> PEOPLE_EXHIBITORS
> -----------------
> #person_id
> #exhibitor_id
>
> The persion_id and exhibitor_id are sequence numbers and they are not
> visible at runtime.
>
> The PEOPLE_EXHIBITORS table is the intersection table and is not
> visibile at runtime.
>
> I want to create a form that display both tables PEOPLE and EXHIBITORS.
> When I do query in the PEOPLE block, I want retrieve all the EXHIBITORS
> associated with a record in the PEOPLE block, and when I query in
> the EXHIBITORS block, I want to retrieve all the PEOPLE records associated
> with a record in the EXHIBITORS block.
>
> Any help will be deeply appreciated.
>
> TIA.
>
> --
>
> --

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow