Let's say we have a table TB1 which contains the following columns -
col_1 <- auto_number & key for this table
col_2 <- text
col_3 <- text
Based on each row inserted into the above table, I need a row to be inserted into a dependent table TB2 -
col_1 <- key for this table
col_2 <- should contain the value of col_1 in TB1
In case there is a combination of values available in TB1 (other than col_1) that can uniquely identify col_1, I could issue a fetch right after an insert to have the col_1 value moved into a ws-, for use in TB2 thereafter...
However, If I don't have key combinations in TB1, that can uniquely identify col_1, what can be done?
It seems like MS programming languages (forgive the reference ;)), provide some feature to extract the inserted autonumber -