Find duplicate records in multiple tables.

Hi, Can anyone point me in the right direction to solving this?

I have a Table which is a parent table with and Primary key ID and data.

I can find duplicate data just fine for that.

There is also a child table for Details which references that primay key in
the parent table and also has its own primary key and data.

There are cases when the data in the parent table is the same but the data
in the child table is sometimes different and I do not know of a way to check
if all child rows are the same or not.

Start by building a query that inner-joins the two tables and returns
the fields you're interested in. Then create a "find duplicates" query
that gets its data from the first query.

On Thu, 15 Feb 2007 13:47:05 -0800, jones6
wrote:

Hi, Can anyone point me in the right direction to solving this?

I have a Table which is a parent table with and Primary key ID and data.

I can find duplicate data just fine for that.

There is also a child table for Details which references that primay key in
the parent table and also has its own primary key and data.

There are cases when the data in the parent table is the same but the data
in the child table is sometimes different and I do not know of a way to check
if all child rows are the same or not.


--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.