N
NutritionHealer
Hi, I can't believe how confused I am! I've spent hours and hours trying to
figure this out!
Here is the scenario:
I created 4 tables and matching forms. One has information from business
leads that I purchased (name, address, phone, email, etc) Another table has
info about my family and friends. Another has data from people who contacted
me that I did not previously know. So all of these tables contain basic
contact information common to all three, plus each table has info that is
different from all the others.
The last form and table I wanted to be a contact list of "all the people" in
the other 3 tables with just the information common to the other 3 tables
included.
I've tried using the phone number as the primary key. If I create a
relationship from the contact list to all the others will the contact list be
suddenly populated with the names from the other 3 lists. In other words, If
I open the contact list form, will the names from the other 3 appear in the
new database so I can use the phone dialer etc?
I guess the basic question is: Is it possible to have 3 separate lists merge
into 1 called the Contact list?
Thank you,
Sign me, One of the most frustrated people to have ever lived!
figure this out!
Here is the scenario:
I created 4 tables and matching forms. One has information from business
leads that I purchased (name, address, phone, email, etc) Another table has
info about my family and friends. Another has data from people who contacted
me that I did not previously know. So all of these tables contain basic
contact information common to all three, plus each table has info that is
different from all the others.
The last form and table I wanted to be a contact list of "all the people" in
the other 3 tables with just the information common to the other 3 tables
included.
I've tried using the phone number as the primary key. If I create a
relationship from the contact list to all the others will the contact list be
suddenly populated with the names from the other 3 lists. In other words, If
I open the contact list form, will the names from the other 3 appear in the
new database so I can use the phone dialer etc?
I guess the basic question is: Is it possible to have 3 separate lists merge
into 1 called the Contact list?
Thank you,
Sign me, One of the most frustrated people to have ever lived!