Append records where non exist (1 Viewer)

CraigBFG

Registered User
Joined
Aug 21, 2003
Messages
68
Pulling my hair out with this one! :mad:

Append/insert records which exisit in the template table but don't exist in the working table against a specific Project ID.

The working table contains MANY other records relating to specific ProjectID's. So the actual process should be.....

tblTemplate
1.Rec1
2.Rec2
3.Rec3
4.Rec4

tblWorking (existing records)
ProjId1 - Rec1
ProjId1 - Rec2
ProjId2 - Rec1
ProjId2 - Rec2
ProjId2 - Rec3
ProjId2 - Rec4

Where ProjID = 1, append to working table from template table rec 3 & 4.
Where ProjID = 2 - no records appended as all template records already exist.
Where ProjID = 5 - no records exist so append all from template.

Help would be highly useful ! :D
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom