Autocode for records.

[Goldenbird]

I have seven tables. The tables already contains Autofields for Roll Nos. What I want is combine all the seven tables in one table or combine all reports in one and generate a confidential autocode for every candidate. I combining is not possible this can be done for single tables also. But, if the autocodes have been used in one table then it should not be used in another table. Please help

[Goldenbird]

OK, Let me simplify the question. I have a table in which I want to insert one extra field and want to generate Autonumber for giving secret codes for each and every student. For ex. autonumber could be generated as for Craftsman posts cfa1bcf, cfa1cfcf i.e. mix numbers/text , but the code should be unique for each and every candidate, for his identification or any other example as you deem fit. This code should not repeat for any other candidate. This solution is urgently required as the open exam is proposed tomorrow and I am database administrator.

[Goldenbird]

Is it possible. Can anyone give a try.