new autonumber in each record

[newegyptian]

i have two linked table












i made autonumber for subform




but it give autonumber continuos in all record

ex : record num 16 have autonumber 2,3,4



in record num 17
the autonumber was 6,7,8



i need new autonumber in each record 1,2,3 ... etc in each record

not 1,2,3 in first record
then 4,5,6 in next record

want to make record num 16 have autonumber of 1,2,3
and record num 17 have autonumber of 1,2,3 not 4, 5,6

how i can do that
?????

[June7]

That is not autonumber. Would have to use VBA code to calculate and save the next number in sequence.

Why bother with this? What purpose will it serve?

This sequence can be dynamically calculated on report use Sorting & Grouping features and textbox RunningSum property.

[ranman256]

autonumber just grows, it does not start at 1 for every new record (and doesn't need to)
Humans dont need to care about it, only the record does.

[newegyptian]

I want to set visit nimber of each patient

[June7]

Generating custom identifier is a common topic. As stated, requires code. Also stated, can just calculate this sequence in report.

Surely you save the date of each visit? Use that to order records in report, set a grouping on patient ID and use the RunningSum property of textbox to calculate the sequence number for each group. Then you won't need any code.

[newegyptian]

Generating custom identifier is a common topic. As stated, requires code. Also stated, can just calculate this sequence in report.

Surely you save the date of each visit? Use that to order records in report, set a grouping on patient ID and use the RunningSum property of textbox to calculate the sequence number for each group. Then you won't need any code.

Good idea
How i can order record in report?
How i can set groubing on patient id ?
How i can use property of running sum?

Thanks

[Minty]

Good idea
How i can order record in report?
How i can set groubing on patient id ?
How i can use property of running sum?

Thanks

These are all standard report properties / features. Have look here https://support.office.com/en-us/art...2-4a23ac0fdbf3
or play with the report wizard to get you started.

[newegyptian]

i dont want report

i want it to be in form
when i type new record
i need the visit number to be appeared

[June7]

As already stated, requires code.

This is a fairly simple calc. Real trick is figuring out what event to put code in.

DMax("PhoneID", "phone", "ID=" & [ID]) + 1

[orange]

@newegyptian

For more info on Autonumbers, please see this.
It seems you are confused/inexperienced with some database and Access concepts and facilities.
I suggest you watch free youtube videos by Richard Rost (599CD)--here is a series that should help.
For additional info on Database Planning and Design and related articles, try this link.
Good luck with your project.

[orange]

@newegyptian

For more info on Autonumbers, please see this.
It seems you are confused/inexperienced with some database and Access concepts and facilities.
I suggest you watch free youtube videos by Richard Rost (599CD)--here is a series that should help.
For additional info on Database Planning and Design and related articles, try this link.
Good luck with your project.