Just starting on my first expression engine website and I have come up against this stumbling block. This is the scenario…
I want to be able to add a new band and associate a list of members to it. A band can have varying number of members so you can’t hard code a field for say drummer, guitarist in the band channel. In a relational database this would straight forward just have a primary key to link both tables but I have no idea how to handle this in EE…
Will a relationship as described in the User Guide accomplish this for me? From what I understand from reading the documentation is it seems like the relationship is one to one and it won’t return multiple rows of data.. Does anyone have a real example they can provide to me of these relationships in action I am not following the one in the documentation?
Also noticed the module called Playa by Pixel and Tonic.. Will this allow me to do what I want?
I just need someone to point me in the right direction.
Thanks in advance!