I need to make sure that all table 1 entries are in each of the blocks of emails in table tow.
Table 1
StandardMatterEmails - Fields are - StandardEmailsId, StandardEmail, StabdardOwner
Table 2
MatterEmails - Fields are - MatterEmailId, MatterId, EmailAddress, EmailOwner
MatterId defines the email blocks on table two
My simple logic would be
Outer loop would be table 1 - Read first entry of table one - compare it with each entry in the first block-
If you find it jump to the next block, A change in matterId
Means that you haven't found it in the 1st block so add the table 1 email to the first block
then compare to block 2 and repeat the process
When EOF on table 2
Read the 2nd entry in table 1 and go through to EOF on table 2
When EOF on table 1 the process is finished
Has anyone written any code that would do the above please
Any help would be greatly appreciated
Table 1
StandardMatterEmails - Fields are - StandardEmailsId, StandardEmail, StabdardOwner
Table 2
MatterEmails - Fields are - MatterEmailId, MatterId, EmailAddress, EmailOwner
MatterId defines the email blocks on table two
My simple logic would be
Outer loop would be table 1 - Read first entry of table one - compare it with each entry in the first block-
If you find it jump to the next block, A change in matterId
Means that you haven't found it in the 1st block so add the table 1 email to the first block
then compare to block 2 and repeat the process
When EOF on table 2
Read the 2nd entry in table 1 and go through to EOF on table 2
When EOF on table 1 the process is finished
Has anyone written any code that would do the above please
Any help would be greatly appreciated