How to CREATE duplicates

[jess]

I have some survey results for one person living at an address. And I have multiple people living at the same address.

How could I apply the same survey results to all people living at the same address?

thx...jess

[Osman]

hi jess,

i dont understand what do you want to do. please explain more detailed..

osman

[Stuart Taylor]

If the Survey Database and the Contacts Database both contain the street & postcode you could build a relationship between the two that way on the survey the people at that address could be listed and on the Contacts Database the Survey (or surveys) could be listed or results displayed.

Look at the Relationships forum for example files on how to build relationships (its the core of any solution)

[jess]

I've got a project going on where a company is contacting voters and getting responses. Unfortunately, they aren't determining who is answering the questions, just one of the voters living at a certain address. There will be other voters living at that address, but they didn't get a chance to answer the survey.

I need to import thier responses (by matching ID) and apply thier responses to every other voter at that same address.

Imagine that my contacts table looks like this:

ID

Name_First

Name_last

Address

City

Response1

Response2

Response3

Response4

The end result for me is that I have to export out those addresses where there are no no survey responses.

Edited September 10, 2006 by Guest

[Ender]

Hmm, it looks like you're assuming the responses would be the same for all members of the household. Is this some crazy Republican scheme to improve their polling numbers?

If the answers truly should be applied to all members of the household (I suppose this would be true if the questions were about the household, and not about their preferences and beliefs), then you should probably have a Household table for those responses.

[comment]

Hmm.. if you define a self-join relationship on Address and City, you can then get the responses of the household from the relationship. Of course, it's not the correct structure at all, but given what you have..

[jess]

Yes, it is some crazy scheme to inflate numbers..sort of. Actually, based on this group doing polling for us they have real problems identifying WHO is actually answering the questions. If they ask for a specific person on the phone they get something like a 2% penetration rate.

Anyway..we are stuck making bold assumptions. Whoever answers the questions, then that is how the whole household will vote. I don't like that kind of thinking, but I don't make the decisions..just deal with the problems.

So..based on Comment's response I've gotta figure out how to do the self-join and insert those responses to anyone with the same address.

This should be fun.