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

base it on a view

On 21 Jun 98 21:38:58 GMT, wt786_at_vtn1.victoria.tc.ca (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.
>
>--
>
>
>--
Received on Mon Jun 22 1998 - 13:51:01 CEST