Reply to thread

Message: [QUOTE="jules, post: 2557118"] I have to create a database of our clients. They each have their own file number, i.e C1234. From reading all the other posts I understand that I am not supposed to "mess" with the autonumbering so can anybody tell me a way of creating a column where I can put the first file number, say C1234 and it will increase by itself to C1235. Also, as the database will hold a real lot of information I was thinking to create two tables and link them, so would this C1234 number be the link? Please excuse the terminology, am VERY new to database. Thanks in advance [/QUOTE]