Charlotte Foust
cfoust at infostatsystems.com
Wed Aug 24 15:00:41 CDT 2005
An associative table is also called a join table. It contains one record for each combination of keys that occurs in a many to many relationship. So if you have a tblPeople and a tblIndictments, you could have a tblPeopleIndictments that would contain a record for each occuring people-indictment combination. Charlotte Foust -----Original Message----- From: John Clark [mailto:John.Clark at niagaracounty.com] Sent: Wednesday, August 24, 2005 11:03 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Logic issue I'm not sure what you mean >>> prosoft6 at hotmail.com 8/24/2005 1:51 PM >>> John, Have you thought about using an associative table, where the many to many problems are conquered? What does the rest of the list think about associative tables? Julie Reardon-Taylor PRO-SOFT OF NY, INC. 44 Public Square Suite #5 Watertown, NY 13601 Phone/Fax: (315) 785-0319 www.pro-soft.net -- 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