K
Kevin
I am in the process of building an access DB. Field1 in Table1 needs
to have 45 different answers, and the user is supposed to be able to
select multiple answers. I thought of going with a list box, but I had
problems getting answers to populate the field. I decided to create a
separate table for the answers, and then linked the answers to Field1
in the main record table. I created a subform which lets the user
choose answers for Field1 from a combo box. A record is then created
which contains the answerID and the mainrecordID, and the mainrecordID
can have multiple answerIDs. This works very well from a data entry
standpoint, but I'm having a difficult time creating a report to show
this data. I'm trying to take the answers from the subform,
concatenate them into a single string, and then have that string in
the report.
to have 45 different answers, and the user is supposed to be able to
select multiple answers. I thought of going with a list box, but I had
problems getting answers to populate the field. I decided to create a
separate table for the answers, and then linked the answers to Field1
in the main record table. I created a subform which lets the user
choose answers for Field1 from a combo box. A record is then created
which contains the answerID and the mainrecordID, and the mainrecordID
can have multiple answerIDs. This works very well from a data entry
standpoint, but I'm having a difficult time creating a report to show
this data. I'm trying to take the answers from the subform,
concatenate them into a single string, and then have that string in
the report.