The database is already designed as you described in your response. The table to which I was referring was built from separate tables containing the information I described.
That being so, how do I combine these elements (from the separate tables) into a memo field as I described above?
I...
I have a table with an activityID (unique for each user), a questionID and questionText, and an answerID and answerText.
Each user(activityID) has been asked a question and has given an answer set (like a single yes/no answer, or an a,b,d and e answer set).
In a memo field in a table to be sent...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.