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

From: Phil Lee <wt786_at_vtn1.victoria.tc.ca>
Date: 21 Jun 98 21:38:58 GMT
Message-ID: <358d7d72.0_at_news.victoria.tc.ca>



Hi,

[Quoted] [Quoted] 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 Sun Jun 21 1998 - 23:38:58 CEST

Original text of this message