Hello All,
I have one table that shows commission payments and policy numbers
ie Table 1 fields
Inception Date
Policy Number
Commission Paid
I have a second table that shows every tranaction that has been processed on our system.
ie Table 2 fields
Transacted Date
Policy Number
Premium
Source Code
Table 2 will have a number of records using the same policy number for every transaction done on that policy. Each policy has a Source Code which is set when the policy is first set up & doesnt change when further transactions are processed.
My problem is that I'm trying to create a new table that would show all the records from Table 1 and the Source Code from Table 2 used with that Policy Number.
When trying to do this I cant get my new table to show all the records from Table 1 and because there are more than 1 record for that policy number on Table 2 it brings up duplicate entries.
Any ideas???
I have one table that shows commission payments and policy numbers
ie Table 1 fields
Inception Date
Policy Number
Commission Paid
I have a second table that shows every tranaction that has been processed on our system.
ie Table 2 fields
Transacted Date
Policy Number
Premium
Source Code
Table 2 will have a number of records using the same policy number for every transaction done on that policy. Each policy has a Source Code which is set when the policy is first set up & doesnt change when further transactions are processed.
My problem is that I'm trying to create a new table that would show all the records from Table 1 and the Source Code from Table 2 used with that Policy Number.
When trying to do this I cant get my new table to show all the records from Table 1 and because there are more than 1 record for that policy number on Table 2 it brings up duplicate entries.
Any ideas???
