how to implement Many-to-Many relationship in Forms 4.5?
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