Re: Need help with twisty design problem
Date: 13 May 2002 13:52:21 -0700
Message-ID: <c0d87ec0.0205131252.123a6fbc_at_posting.google.com>
>> The columns beginning with 'User...' are the respondent data. The
columns beginning 'DM...' are what the respondent submits as the
person meeting the criteria in 'KeyDM'. However, if the respondent is
also the person meeting the criteria, I don't want to populate
the'DM..' columns with the same data. <<
Why not? They are playing a different role as a "Qualified surveyee" than they played as a "first-time surveyee" -- and they did in fact qualify themselves. There is a real logical difference here.
You might want to prune the relationship table down to user_id's and have a table of all user's data rather than repeated the attributes in two places in the relationship table. Maybe add a few columns about when this happened, etc. Received on Mon May 13 2002 - 22:52:21 CEST