How do i setup a membership database?

I am trying to create a database for my local Allotments Association.

They have two sites, each with up to 50 plots. Plots can have more than one
holder, holders can have multiple plots over both sites.

Keys fo the Shed, Hut and gate can be held by each member.

Rents are payable annually by each member, but at a varying rate according
to age and benefits claiming.

I have tried adapting the Membership Template from MS site, but this falls
over during the breaking and reassigning of the relationships links.

Any help would be greatly appreciated.

Thanks anyway folks

I think i've solved it - I forgot to apply the KISS principle

I was trying to make it far more complex than it needed to be!!!!

"johnedc" wrote:

I am trying to create a database for my local Allotments Association.

They have two sites, each with up to 50 plots. Plots can have more than one
holder, holders can have multiple plots over both sites.

Keys fo the Shed, Hut and gate can be held by each member.

Rents are payable annually by each member, but at a varying rate according
to age and benefits claiming.

I have tried adapting the Membership Template from MS site, but this falls
over during the breaking and reassigning of the relationships links.

Any help would be greatly appreciated.