I have created a very simple Access 2010 database. It has 2 tables: tblParent and tblChild. Each has a primary key on a single numeric column: called ParentId and ChildId respectively. Each has an additional Index (No Duplicate) on text name columns: called Parent and Child respectively...
