I have two tables, table 1 has a counter (autonumber) and table 2 has a sequential set of numbers.
Every time the counter in table 1 increments by 35 I have to update that set of 35 records with the next sequential number from table 2.
Anybody done something like this? Any help appreciated. Thanks.
Every time the counter in table 1 increments by 35 I have to update that set of 35 records with the next sequential number from table 2.
Anybody done something like this? Any help appreciated. Thanks.