One-to-Many Relationships Queries & Forms

[Guest]

I have a normalized database that contains a table which has a one-to-many
relationship with three other tables. When records are added to the
database, the data is stored in all four tables. Now I would like to
retrieve this information through a parameter query, but the query results
display a separate record for each instance of the one to many relationship.
For example, if Record 1 is referenced twice in child table 1 and three times
in child table 2, my query returns six records for what should be one record.
How should set up my query so the many of child tables 1 and 2 are grouped
together with Record 1?

Also, I would ulitmately like to run this query and display the results in
a form for editing. How should I design my form so that the info from the
child tables for a particular record all display (and are editable) of the
form?

Thanks.

 

[Guest]

This is normal behaviour. How do you expect the child records to be grouped
together?

 

[Guest]

I'm not concerned with how it looks in the datasheet view, but are you saying
there is not a way to group the child records together in a form or report?

 

[Guest]

For a form you would use subforms for the child records. For reports, you
could euther use Sorting and Grouping or sub reports depending on how you
want the data on the report presented.

 

[Guest]

I think I have it, but I just want to make sure I am going about this
correctly. I am going to create a query that will pull data from the parent
table. My main form where the information will be displayed will be created
from that query. The subforms for the child tables will not be referencing
data in a query, but from the child tables themselves. Do I have that right?