I have a survey form - with four values for each row (datasheetview).
CustomerID, UserID, QuestionID and ResponseValue. Employees will answer
the
same question for 100 customers. ResponseValue is a combobox with values
1-5
The four values will be stored in a table called "Tbl_responses" but I
want
the form to be populated from a table of customers, users and questions.
The
values for the combobox will also come from a table but I want the
reponding
value to be stored with the 3 other values
Can someone point me to a link on how to create this then store the value
in
the responses table when the user closes the form? I assume I need some
form
of an append query but I'm not sure how to design the logic.
