T
Ted
Hi all,
I have a Claims system where there are multiple transactions per claim. Each
of these transactions has a Transaction ID. Each Transaction now needs a
Transaction # per claim. Going forward this is not a problem but is there an
easy way to go back and update the TransactionNumber field? I have a
DateTime
Stamp (DateEntered) to let me know the order of the transactions. So for
example
i could have 100 transactions which will have Transaction IDs of 1-100 but
now they need a Transaction # per Claim. If a Claim has 10 Transactions they
should be numbered 1-10 and if another claim has 8 transactions they should
be numbered 1-8.
any help or direction would be very much appreciated
TIA
Ted
I have a Claims system where there are multiple transactions per claim. Each
of these transactions has a Transaction ID. Each Transaction now needs a
Transaction # per claim. Going forward this is not a problem but is there an
easy way to go back and update the TransactionNumber field? I have a
DateTime
Stamp (DateEntered) to let me know the order of the transactions. So for
example
i could have 100 transactions which will have Transaction IDs of 1-100 but
now they need a Transaction # per Claim. If a Claim has 10 Transactions they
should be numbered 1-10 and if another claim has 8 transactions they should
be numbered 1-8.
any help or direction would be very much appreciated
TIA
Ted