Linking several tables

[faxylady]

Here's a new twist to the problem I've been working on. I have about 50
tables with contact information. These tables will be used to send out
faxes. There are duplicated contacts throughout the tables. I do not want
to send a fax to the same number more than once and when someone calls to say
"take me off your list," I want to make sure they are removed from the one
table as well as all others. How can I do this?

 

[Roger Carlson]

Why do you have contact information in so many tables? I can't think of a
reason to have more than one or two. Usually only one.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Immanuel Sibero]

Hi Faxylady,

Are all the 50 tables structured exactly the same?
If so, use Union query to combine all the tables and use the total query to
group the records by FaxNo.

To take off someone from the list, I would use the same union query and do a
search on the FaxNo. Whenever there is a match:
- Either delete the record
- Or flag the record to indicate exclude from faxing (I would prefer this
since I would still retain the contact information)

Can you not combined all the contacts into one table?

HTH,
Immanuel Sibero

 

[John Vinson]

Here's a new twist to the problem I've been working on. I have about 50
tables with contact information. These tables will be used to send out
faxes. There are duplicated contacts throughout the tables. I do not want
to send a fax to the same number more than once and when someone calls to say
"take me off your list," I want to make sure they are removed from the one
table as well as all others. How can I do this?

By properly normalizing your table structure, filling the new
normalized tables, and DELETING ALL FIFTY of these redundant tables.

With a properly normalized structure, you will have only *one* record
to delete.

With your current hodgepodge, there is no easy way.

John W. Vinson[MVP]

 

[faxylady]

Thanks for so prompt a reply. If you see my previous, most recent posts, you
will see that I'm trying to do just that. No,the structures are not all the
same. The BIGTable that I am trying to combine all the other tables into has
the most fields. The other tables have the same fields but fewer of them.
Some tables are giving me problems with append queries. An error message
comes up saying over two thirds of the records have validation rule
violations. The BIGTable has been checked and no validation rules have been
found. The smaller tables were imported from Winfax as dBase III files first
into Outlook, then into Access. Please help. Thanks.

 

[faxylady]

These tables were created from the importing of Winfax dBase III files that
were on diskettes. They originally were compiled from all sorts of different
sources. The Winfax files were originally imported to the desktop, then to
Outlook, then to Access.

 

[faxylady]

That is exactly what I'm trying to do now. I am using the Append query to
copy most of the data in the tables into a BIGTable. I am having some
problems with some of the tables.

 

[John Vinson]

That is exactly what I'm trying to do now. I am using the Append query to
copy most of the data in the tables into a BIGTable. I am having some
problems with some of the tables.

Please do me a favor. I think this append query can be solved with a
bit more information.

Open one of the queries that's giving the error in SQL view and post
the entire SQL text here. Also indicate the datatype of each field in
BIGTable; and open the Relationships window and click the "show all
relationships" button, and let us know what (if any) relationships
BIGTable has.


John W. Vinson[MVP]