Kathryn Bassett
kathryn at bassett.net
Sun Jul 22 17:55:38 CDT 2007
Maybe a screen capture will get someone to help me. http://www.genealogylibrarycenter.com/images/manymanyrelationship.jpg First, the word foreign in the tblCSjoin bottom field name has been corrected, so ignore that. The word was intended to be in the description. Now, here's my problem. I've only ever done Many-One or One-Many, I've never done a Many-Many and don't know how to join the tables. I've tried some different combos and nothing will turn that One-To-Many into Many-To-Many. And I'm not clear on Enforcing and the Cascading either. A name can belong to many collections. A collection can have many names. There is never going to be two people of the same name. Don't be concerned with why not, just be assured I've got my reasons, and a solution. So, how do I drag the tblCSjoin's foreign key's to the primary keys in the other tables, and what all do I checkmark? I'll get to other question after this part is solved. -- Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is my soap" kathryn at bassett.net http://bassett.net No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.12/910 - Release Date: 21 Jul 07 3:52 pm