E
Ed
I have 2 tables, TBL - Claims & TBL - Transactions. This is a one to many
relationship, 1 Claim has many transactions associated with it. The issue
arises in the fact that I receive the data feed of the transactions, and need
to populate certain fields into the Claims table. The Claims table contains
a unique primary key, Claim Number. This number is a field on the data for
the transaction. What I am thinking I need to do is a find Duplicate query
to return just each unique claim number and then append to claims table.
Any info is greatly appreciated.
Ed
relationship, 1 Claim has many transactions associated with it. The issue
arises in the fact that I receive the data feed of the transactions, and need
to populate certain fields into the Claims table. The Claims table contains
a unique primary key, Claim Number. This number is a field on the data for
the transaction. What I am thinking I need to do is a find Duplicate query
to return just each unique claim number and then append to claims table.
Any info is greatly appreciated.
Ed