Thanks for the response to my query. I have put a page together (zipped & attached) and hope you can clarify a couple of issues for me.
I've put a form on the page which hopefully uploads some fields to the reviews table and also to the reviewers table. I did this by running the DA wizard to create an insert page to insert records into the reviews table, then added additional form fields and a DA insert record behavior to insert these into the reviewers table. To do this I have a separate recordset for each table.
I should stress that I haven't tested this yet so I don't know whether that part is right or not. My problem is this - I want the reviewers to be able to select from 3 drop down menus at the top of the form the location, the type and the name of the vet practice respectively. So, I've added a drop down for each and bound them using a third recordset, then altered the code in the recordset to select DISTINCT for each. However, that's not happening - when I test the page locally using MAMP, I'm getting a page which loads slowly, with the 3 drop-down menus building first, then the rest of the page. And when it's fully loaded, I've got multiple instances of locations rather than one of each, which isn't what I wanted.
So... the question is, how do I alter these 3 menus so that they do what I want (which is for the reviewer to pull down the location first, then the type, then the name of the practice, then fill out the form to upload a review that's specific to that vet in that location)? Thanks in advance for your help.