Access Db
in access 2000 is it possible for the auto number to carry on???? as i have 4 different tables but for this page i want them all to act as one so i was wondering if the ID could carry over. So in table 1 it could be 1-5, 2 could be 6-7, 3 = 8-15, 4=16-25. But if i was to add a record in 1 so that would then be 1-6 it would move the ID up oneAnyone????