What records are not appended

[rehanemis]

Hi,

I would like to get the list of records of TableTmp are not appended into MainTable. both Tables has same fields name and data type along with primary key.

Thanks and waiting of your suggestion.

Regards
Rehan

 

[plog]

I would like to get the list of records of TableTmp are not appended into MainTable

Huh? Who's doing the appending? Just check out the query and it will give the criteria for those not appeneded?

 

[rehanemis]

I am doing the appending but later my Clerk may do it. I just want to view all those records which are not appended.

 

[James Deckert]

Hi,

I would like to get the list of records of TableTmp are not appended into MainTable. both Tables has same fields name and data type along with primary key.

make a query with TableTmp joined to MainTable on the PK. Then in the criteria put IS NULL in the PK field of MainTable PK field. Edit join line to show all records from TableTmp.

 

[rehanemis]

But there is issue. just Suppose MainTable has Primary Key as : Sr_No and contains 1 to 5 records(1 2 3 4 5). Similary TableTmp has also Sr_No Field with Same records(1 2 3 4 5). so in this case no record will be appended due to primary key on MainTable. I would like to view the whole (1 2 3 4 5) records which are not appended.

did you got my point?

 

[James Deckert]

How do you know if a record is appended or not?