| Index
» Projects
» phpMyEdit
» Forum
» Configuring for many:many relationships |
 |
jjk3
Joined: 08 Jan 2007
Posts: 3
Posted: 2007-06-08 17:28
Back to top
Reply with quote
|
Is it possible to configure phpMyEdit to support many:many table relationships?
For example, I have the following tables:
organizations
systems
An organization can be associated with many systems, and a system can be associated with many organizations. So I have an extra junction table:
org_sys
This one just contains foreign key pairs that link the two original tables. How can I set up phpMyEdit to support this junction table transparently? Is it possible? I'm thinking something like when editing an organization, being able to select multiple systems, and vice versa, and having it automatically create the right records in org_sys.
Thanks in advance.
|
jorges
Joined: 20 Aug 2007
Posts: 2
Posted: 2007-08-20 03:47
Back to top
Reply with quote
|
i didnt manage to use phpMyEdit to do the job, maybe there is a way, but i dont think so...
What I did was I created triggers after insert to update tables accordialy, but this is a quick fix, not a fully integrated solution.
Have you had any luck with this?
|
jjk3
Joined: 08 Jan 2007
Posts: 3
Posted: 2007-08-20 15:11
Back to top
Reply with quote
|
Sorry, I have not. I've since switched over to another database system to solve my problem.
|
jorges
Joined: 20 Aug 2007
Posts: 2
Posted: 2007-08-20 23:37
Back to top
Reply with quote
|
would u mind if i ask which one?
|
jjk3
Joined: 08 Jan 2007
Posts: 3
Posted: 2007-08-21 14:32
Back to top
Reply with quote
|
Oh, I switched from MySQL altogether. My project was small enough that I'm using MS Access now.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
