If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Find duplicate records in multiple tables.
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. |
Thread Tools | |
Display Modes | |
|
|