Pulling my hair out with this one!
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 !
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 !