OK, making progress here - I now have three recordsets so that location, type and name are now loading quicker and are showing only one instance of each value.
However, what's more concerning is that the insert doesn't seem to be working - I tested it and it was inserting "reviewersname" rather than the value on the form, so I've made some adjustments and got that sorted, but only some data was being inserted into the database, so I looked through the insert record server behaviors again and made a couple of changes. Now I'm getting this error when testing locally:
Duplicate entry '0' for key 2
Looking at the two insert record server behaviors I think it's something to do with the insert of the comments and the reviewrating - that clearly isn't working properly. I've attached the latest version of this page (zipped) and hope you can clarify what's going on here. Thanks in advance once again.