Relational data on results page
I have a two tables, Table one is the issue being voted on and Table 2 just contains yes, no, maybe. On the Insert page I have drop downs, popluated from Table 2, where they each select their answer, yes, no, or maybe and inserts the id into Table 1.
Problem is, on the results page it currently shows just the number. I was able to edit the recordset to get it to display the yes, no, maybe for the first voter but everything blows up from there.
So for each of the voters and for each of the records it should pull the english from Table 2 to display on the results page.
I hope I'm being clear. Thanks. I've attached a text file the the results page.