Multiple serial numbers

[Ali Omran]

Hii

i am currently working on creating a database for our department and i came across a way of doing this to record everything in one table.

but the problem is i cannot use multiple auto number for more than once.

allow me to explain.

we received applications and for example they are:

1- Offering Tickets
2- Credit Applications
3- Memo
4- Investment

each should have its own Serial Number and on Autonumber.

since its against the policy to attach the Database, i created an example of what am trying to do which:

1- a field to capture what type of application
2- a field to show the latest Serial number used and next to it is a generate button that simply generates a new Serial number.
3- and below are all the details to be written.

but i failed to write down the code as i am not very experienced.

i only knew how to write Dmax for calculating accumulated SN.

Kindly find the attached

 

[Ranman256]

Use a parent-child sub table.
Parent has autoNum,child has autoNum.

 

[jdraw]

It is extreeeeemely rare to have a 1 table operational database.

Start with a description of the business you are trying to support with automation.
Work through this tutorial from RogersAccessLibrary. It will take less than 1 hour, but you have to do the work. You will learn.


As for Access, do not use embedded spaces or non-alphanumeric characters in your field and object names.

Good luck.