I have fixed it. I did need both repeat regions I just needed the repeat selection to be inside the repeat region. I had it the other way around before.
I have another question. I only want the record to be inserted if the user selects a particular day on a room type for example if the user selects a single room on Monday and Tuesday and a double room on Tuesday and Wednesday - I only want those 2 records to be inserted - I don't want the triple room and the quadruple room to be added (with blank values). I can get it to work by adding a checkbox with the room type as the value and then on the multiple insert it only inserts if the checkbox is ticked ($WA_insertIfNotBlank = "Occupancy";). The problem with this is that often the user is just selecting the days and not ticking the roomtype check box. Is there a way that I can say if (MonTotal OR TueTotal OR WedTotal OR ThurTotal OR FriTotal OR SatTotal OR SunTotal) is not empty
insert the record.
So instead of:
$WA_insertIfNotBlank = "Occupancy";
It would say something like:
$WA_insertIfNotBlank = "(MonTotal || TueTotal || WedTotal ||ThurTotal || FriTotal || SatTotal || SunTotal)";