I have one table called Album
another table called Song

One Album has many songs

I created an Album form that contains a Song Subform.

in the Song table I have a field id which is the primary key, and
another field called index

The song index is a number that represents the song number on the record.

For example on the Beatle's Album: Abbey Road the song indices are as
follows:

Track Listings
1. Come Together         
2. Something         
3. Maxwell's Silver Hammer         
4. Oh! Darling         
5. Octopus's Garden         
6. I Want You (She's So Heavy)         
7. Here Comes the Sun         
8. Because         
9. You Never Give Me Your Money         
10. Sun King         
11. Mean Mr. Mustard         
12. Polythene Pam         
13. She Came in Through the Bathroom Window         
14. Golden Slumbers         
15. Carry That Weight         
16. End         
17. Her Majesty         

My question is.....on the song subform how can I get the song index to
automatically have the index inserted based on the number of tracks
already entered.  In other words a running count?

For your information, here are my tables

Table: Album
Primary Key: id (number)
name (text)

Table: Song
Primary Key: id (number)
name (text)
index (number)
albumID (foreign key)

Relationship is One Album to Many Songs with Referential Integrity.

I really appreciate your help.