Hi everyone my first post and I am pretty sure its not my last
Here is the thing guys
I started a access DB with more than 700 hundred records.
I have CusID Field which is a primary Key in VIPsInfo table and foreign Key in other tables.
My problem now is i made the CusID data type (Short Text) and i used to enter it manually.
I am looking for changing my manual entry to an Auto numbering or auto filling .
i know it was a stupide thing for me to do it at the first place and foolish thing to hope it can be fixed after 700 hundred records.
one more thing my CusID sequence is "CUS0001,CUS0002...CUS0700..."
i think this is everything