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.
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.
any help or direction would be very much appreciated
TIA
Ted