Where can I download this type of db example?

[Jay Wolfe]

Hi, I'm working in Access 2003.

Where can I download a (free) Access database example that shows how to
implement forms and queries for tables that break down many-to-many
relationships with a link table? I understand normalization and I believe
my structure is 3rd order normalized. I need to figure out how to input
data into the tables and have them linked together automatically by a query
(or, if necessary, VB code). In other words, a database that has

tblParents (1->oo) tblParent_Child_LINK (1->oo) tblChildren

where (1->oo) means One-to-many, if it wasn't clear. Each of the LINK
tables have 2 fields, an ID field to match each of the tables. (e.g.
tblParent_Child_LINK has ChildID and ParentID fields)

I want to work with an example that shows how to implement updatable queries
and forms for this kind of table structure.

I downloaded this example db:
http://www.databasedev.co.uk/many_to_many_example.html

which is good, but very simple. I'm looking for something with a little
more sophistication on inputting data into forms that access multiple linked
tables..

Can you point me to some db's?

Thanks!
Jay

 

[Douglas J. Steele]

Take a look in the Northwind Traders database that comes with Access.

The Orders form (which uses the Orders Subform form) illustrates how to do
this. The tables involved are Orders, Products, and Order Details (which
resolves the many-to-many between Orders and Products)

 

[Jay Wolfe]

Yeah, I had looked at this but I guess I didn't think it had enough ways to
input info. I'll go back and look at it again. Thanks for pointing that
out

Jay