That solved it. Thanks Ray. Now that is all working I have an advanced issue I need help with as follows.
The membership will be for a block of flats with a base fee of £10.00 and then £1.00 per flat in the block. For example a block of 50 flats will be £10.00 plus £50.00 totalling a cost of £60. I am unsure of the best way to set this up. It currently only has the £10.00 as the charge. I have the two columns in the DB table as 'base_charge' and 'price_per_flat'.
Thanks in advance.