Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subform Problem
Message
From
10/08/2004 01:18:45
 
 
To
09/08/2004 11:59:11
General information
Forum:
Microsoft Office
Category:
Access
Title:
Miscellaneous
Thread ID:
00931794
Message ID:
00931953
Views:
17
Hi Stacy:

What do you see when you run the underlying query?

The query behind a child table (the "many" table) should have a "foreign key" which is the "primary key" of the parent table (the "one") table. In other words, each child should have the mark of the parent on it!

The child query will have a parameter on this "foreign key" so that the table asks for the children of a particular parent.

Because there are (in principle) more than one child for each parent, the form will want to use a grid to display all the children. From there, select a child and view it in detail.

Hope that helps

-gn-
Godfrey Nicholson
Ofek Technologies Ltd
Auckland
New Zealand
Previous
Reply
Map
View

Click here to load this message in the networking platform