Autonumber generate when required problem

[Swillsy]

Hi All,

Ive got a problem with my table design I'm hoping someone might have solution for:

Noramlly I have studentIDs generated on a central database which links my whole databse together.

However I will need to generate new numbers for non-students so that the database is still linked. Is there anyway that access can build these numbers for me automatically and in a certain format such as;
n0001, n0002 when required?

Thanks

Swillsy

 

[DCrake]

If you create a new table with the same structure as the student table, then change the auto number format to suit your needs.

You will then need to use a union query to sit on on top of the other to make one large table with unique numbers in each table.

 

[Swillsy]

Hi Dcrake,

Thanks for Reply I didn't know you could format the autonumber.
the work around i created in the end was to create another table:

Autonumber column
PersonID column
Name column

Then I used a form where you enter in a name and in the PersonID field I used some VBA to basically add digits to the Autonumber like so
field = "PI" & forms!form!Autonumber

A bit messy but got it working.