i tried to look for an answer but im pretty confused with what i found..
I'm trying to create a many to many relationship like in SQL..
lets say i want to create a custom 'Event'(a field set), so i make some fields(name,date,location etc..) BUT now i want to make a custom 'Team'(field set) which has an 'events' field that contains the id's/names of this team events.
thanks in advance!
okay let me try with a diffrent example: im making a managment system for a soccer team. so lets say i make a 'Court'(field set) with fields like name,address etc.. and now i want to make a 'Team'(fieldset) which contains all the diffrent Court's this 'Team' has.. is it possible to link many 'Court' records to a specific team? and each 'Court' has its related 'Team's ? i hope i made it more clear..