I thought I'd give it a whirl and add some insert behaviours as suggested, so created two more recordsets - one for the comments to insert into my reviews table, and the other to insert the reviewers' details into the reviewers table. I then tried testing it locally and I got a fatal error message; a quick search on here indicated that the include call for the DA App Builder file had been inserted too low down the page - it had, so I moved it up under the include call for the Connections file. I ran through the add review procedure using my local server, and the review was added to the db and I was redirected to the "thanks" page as anticipated, so I thought I'd cracked it, so I tried adding a second review, and got this error:
Duplicate entry '0' for key 2
I had no idea what this meant, so I searched on here and decided that it had something to do with the fact that the practice_id number is being added to the table as '0' each time, which is why the second review wasn't added. In other words, the practice_id isn't being passed through, which means that the review isn't linked to the correct practice, so I need to sort that somehow. I presume this is a similar thing to needing to pass the child list value (above)? I've just manually added the correct practice id number to the reviews table, and then added another dummy review and it's inserted that into "reviews" perfectly, but again with the practice_id '0'. Any suggestions how to ensure that the correct practice_id is pulled from the parent/child drop-downs and inserted into the "reviews" table?
