QUERY Problem

[Guest]

I have two tables "table1" and "table2" 1 to many relationship "table1" is
the parent. How can I run a query where I only want to see the top record of
the child data. EX:

Table1: Joe, Jane, Ted
Table2 (Joe)=>1, 2, 3, 4 (Jane)=>1, 2, 3, (Ted)=>1, 2, 3
I only want to see:
Joe 1
Jane 1
Ted 1
===NOT===
Joe 1
Joe 2
Joe 3
Joe 4
Jane 1
Jane 2
etc..
Thanks all

 

[matthew]

In the query window, go to tools and choose totals. Then
in the field in the child table choose Ascending in the
Sort Line. Then in the Total: line, choose the option
that says, "First".
Let me know if you need clarification on anything.
matthew

 

[Guest]

In the query window, go to tools and choose totals. Then
in the field in the child table choose Ascending in the
Sort Line. Then in the Total: line, choose the option
that says, "First".
Let me know if you need clarification on anything.
matthew

 

[Guest]

table 2
Primary Key: num_id --> populate with 1,2,3,4,5,6 -->

on the Query tab create new

table1 table2
jane 1
ron 2
mike 3


on the grid
name, num_id

note: no links on table1 and table2