I agree with Jeff.
Further, in case you had seperate tables for seperate 'sets' of contacts, you
can add a field 'Set' to this united table in which you store a value indicating
the original set/table of contacts these records come from. (1) Like this, you
can lateron still select one set of contacts with a filter/query using this
field.
(1) As such, you could act like this:
- make all field names & order in all tables identical
- add the new 'set' field to each table and use an update query to fill this
field in each table with the value you want to assign to that particular set of
contacts.
- copy one of the tables and name it e.g. tblAddresses
- add the contents (exept the ID, supposing this is an Autonumber) of the other
tables to tblAddresses (copy/paste or ...) and use this from now on as your
'only' address table
Jeff Boyce schreef:
David
If you are saying you have multiple tables, each structured identically, you
may need to consider normalizing your data before proceeding.
While it is possible to build a massive UNION query to combine all of those
into one query, it would be far simpler to have a single table, which you
could then query by, say, street, to get your contacts.
Good luck!
Jeff Boyce
<Access MVP>
--
Hans Vanmechelen
MMIS - Databanken
tel : 02/553.80.14.
mail : (e-mail address removed)
------------------------------------------------------
Ministerie van de Vlaamse Gemeenschap
AMINAL - directoraat generaal
CENTRAAL AANSPREEKPUNT LOKALE OVERHEDEN
Koning Albert II-laan 20 bus 8
1000 Brussel
tel 02/553.80.39 - 02/553.80.81
fax 02/553.80.06
mail : (e-mail address removed)
http://www.samenwerkingsovereenkomst.be