Quote:
Originally Posted by wisconsin54022 
Hello
i have a table1 with a number 1250 in access 2007. Looking for some code that a table2 could use as an autonumber. we it runs it would look at table1 number has 1 added to it, then update 1250 to 1251 in the table1. If table2 has another row it will do the same as before. Let me know if this doesn't make sense.
Thanks for any suggestions.
You have a table with records that has a colunm containing 1250 as value in a field and you want to updat that value with +1 and then you want to have a second table to look for that particular value(1251) in the first table?
