[AccessD] combo from multiple sources

Drew Wutka DWUTKA at Marlow.com
Tue Feb 20 11:06:15 CST 2007


Right, but it is a potential many to many.  Ie, 

There may be an Arthur Harkins by birth, and one by alias, there also
may be 2 different people that both use Arthur Colby as an alias.

So your people table would have every person listed once, your alias
table would have every Alias name listed once (regardless of how many
people go by Arthur Colby, or John Doe).  Then you'd have a many to many
table, one column being the ID of the people table, and the other the ID
from the alias table.

When they need to find Alphonse Cabonnell, the query would be a UNION
query between the name field of the people table, and the join of the
alias/many to many table.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Tuesday, February 20, 2007 10:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] combo from multiple sources

Personally, I wouldn't keep the aliases in a separate table, for exactly
one reason. Suppose that during my criminal career I had the following
aliases:

Arthur Harkins
Arthur Hindman
Alphonse Carbonnell
Arthur W Colby
Arthur G Brock
Arturo Francisco Tapia
etc.

Presumably all these are tied to the birthname of the malfeasant Arthur
Fuller. I would keep them all in a single table, with a column in it
called OriginalPK, that was based on some unique identifier such as SSN
or SIN (in Canada). For police applications, I think this is permitted.
At any rate, I don't care that Arthur Hindman uses the alias Arthur
Colby; what I care about is that Arthur Fuller has many aliases. This
could be achieved with separate tables, but I don't really see the
advantage to doing so. There is also the (potential) issue that the
miscreant in question stopped using a particular alias at some point.
 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: Susan Harkins <ssharkins at setel.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Tuesday, February 20, 2007 11:01:53 AM
Subject: Re: [AccessD] combo from multiple sources


At one point I wanted to show every name associated with a case in a
combo 
to identify which name was used.  This included alias's which were in a 
different table.  So I needed data displayed from 2 different
tables...and I

just used a UNION query as the source.

Does this address your question?

==========About the rant? Nicely done. :) 

As for the combo box -- it would be for display? You weren't using it to
filter other data? Sounds like an interesting project btw. :) 

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list