| Many to Many relation [message #77428] |
Wed, 16 April 2003 04:00 |
Vincent Van den Broeck
Messages: 7
Registered: April 2003
|
Junior Member |
|
|
Hi,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
