Subform Counting Items

[ZJGMoparman]

I have created a Flight Log Database for my radio controlled airplanes. Right now I have a Table and Form for each flight session. I also have a FlightT and Form that is used to record individual flight information for each flight session. I am not creating a subform within the Session form that list all flights from that session. Is there any way I can have the subform number each flight for the flight session? If i had three flights for that flight session, I want it to number the 1, 2, 3. I am sure I would need some type of query to do this, I am just not sure how.

Any help would be greatly appreciated.

[June7]

You can use code to assign and save the sequence to field. Something like:

Me.FlightNum = DMax("FlightNum","tablename","Session=" & Me.SessionID & "AircraftID=" & Me.AircraftID) + 1

Or can do a ranking query. Review http://allenbrowne.com/ranking.html
The table will need a unique ID field, autonumber will serve that purpose.