Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Many to Many relation
Many to Many relation [message #77428] Wed, 16 April 2003 04:00
Vincent Van den Broeck
Messages: 7
Registered: April 2003
Junior Member

I'm making an database with the portal with serveral tables.
There are 8 basic tabels. One is the most important and is linked with the 7 tables with a many to many relation.
as example for the relation lets say there's an Person table and an addres table.
each person has an id (pid) and each addres has an id (aid). each person can have one or more addresses, and each adress can be related to one or more persons.

So I need an table which connects the Pid with the Aid.

So then I have 3 tables for each relation. Is there anything in the Portal to do that. Or is it just impossible. The Master Detail form is great to manage one to many relations, so I can't imagine there's nothing to handle many to many relations.

Best regards

Vincent Van den Broeck
Previous Topic: Error in calling portal
Next Topic: Batched Input
Goto Forum:

Current Time: Tue Aug 04 12:57:06 CDT 2020