G
Guest
I have a table of checks. The PK on the table is the CheckNum field. The
table also has a column ReissuedCheckNum to indicate if the CheckNum was
reissued with a new CheckNum. I'd like to be able to trace a history of the
checks through the table and then tag them with an ID, as in the following
example. There is no limit as to the number of times a check can be
reissued, so I assume the process would need to loop through the table. I'm
not familiar with VB, so any help would be appreciated.
CheckNum ReissuedCheckNum ID
500 501 1
501 503 1
502 505 2
503 1
504
505 2
table also has a column ReissuedCheckNum to indicate if the CheckNum was
reissued with a new CheckNum. I'd like to be able to trace a history of the
checks through the table and then tag them with an ID, as in the following
example. There is no limit as to the number of times a check can be
reissued, so I assume the process would need to loop through the table. I'm
not familiar with VB, so any help would be appreciated.
CheckNum ReissuedCheckNum ID
500 501 1
501 503 1
502 505 2
503 1
504
505 2