Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » which pattern?
which pattern? [message #340] Fri, 27 October 2006 06:45 Go to next message
galdiolom is currently offline  galdiolom
Messages: 3
Registered: October 2006
Location: Padova ITALIA
Junior Member
Hi,
I still have a stupid question, but hope that someone can help me...

How can I implement the RADICORE architecture in a situation like this:

I have to insert (add) one(more) musical instrument(s) to one (more) musician(s) related to a specific track (that, in turn, is corrrelate to a specific musical record)
Which pattern I must use?

The structure is:

- table INSTRUMENTS is related to table LINK_MUSICIAN_TO_TRACK in a MANY-TO-MANY relationship where LINK_INSTRUMENT_TO_MUSICIANxTRACK is the link table;

- table MUSICIANS is related to table TRACKS in a MANY-TO-MANY relationship where LINK_MUSICIAN_TO_TRACK is the link table;

- table TRACKS is related to table RECORDS in a ONE-TO-MANY relationship.
Re: which pattern? [message #341 is a reply to message #340] Fri, 27 October 2006 09:13 Go to previous message
AJM is currently offline  AJM
Messages: 2312
Registered: April 2006
Location: Surrey, UK
Senior Member
When dealing with many-to-many relationships there are several alternatives. If you look in the menu systems maintenance tasks you will see 3 alternatives for dealing for dealing with menu items:
(1) pattern MULTI2
(2) pattern LINK1
(3) pattern LIST2

You need to look at how these operate then pick the one that suits your purposes best.


Previous Topic: Convert XMI to PHP
Next Topic: Failure with Rename Task
Goto Forum:
  


Current Time: Sun Jan 29 08:27:00 EST 2023

Total time taken to generate the page: 0.01500 seconds