I wish to have a Gym object that contain zero or more members as a related list. So Gym is the master and Member is the detail side - but the Member records does NOT have to be linked to any particular Gym.
A given Member record can be attached to 0 or more Gym
Basically, when I create (or edit) a Gym record, I want to be able to attach 0 or more Member records to that Gym record.
In the related list page block - I do NOT want the New button to create a NEW Member record - instead, I wish to do a lookup of Member records and to attach as many of these as I require for the master Gym record (not just a single lookup - as per the Account lookup when I create a Contact lookup)
What is a good way to implement this ?