Join Table or Add Fields to Existing Table?

Discussion created by slraymond on Oct 23, 2013
Latest reply on Oct 25, 2013 by Mike_Mitchell

Forgive me if this question betrays a lack of experience:


I have a customer database. On the customer form, there are tabs. One of those tabs will contain that customer's response to survey questions. There are quite a few questions -- say three dozen or so.


I envision a scrollable list of responses inside the tab. I don't think this is a join table situation; the questions don't change from one customer to another. It seems that it might be easier simply to create a field in the customer table for every question, although I'm not sure how to get the responses to fit a long-narrow table in a scrollable window.