I have attached the files that I created for craig's recordset and database. Not my files. The info needs to populate in the detail page. I have seen this done a different way using "AS" in the SELECT area and with JOINS to the databases. I tried to figure that out but couldn't.
OTHER PROBLEMS. (detail page)
Every once in a while, I change info in my recordset, and it adds two recordsets of the same and then it doesn't work. As soon as I commandZ it goes back and then I add it again, and it doesn't add the second recordset. WEIRD and time consuming!
Also, when adding AND's, I only seem to be able to add so many and then I get "no record found". Does mysql only allow so many AND's? Or would that be because maybe my code isn't correct on the next grouping? Below is what I used that works, then I add another one it doesn't work. ( I will review my code again on that but wondering if you can only use so many??)
FROM members JOIN bondamt, mdbe, chapters, committees, activemem, typeMEMB ON members.bondamount = bondnum AND members.mdbeStatus = dbeNum AND members.chapter = chapterNum AND members.committees = committeesnum