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