There is no Trns_ID field in any table. Exactly what do you want to do - assign a sequence number to each transaction under each flight? getNextItemNum() cannot be used for that. Review http://allenbrowne.com/ranking.html
Access 2007 should be able to read Access 2010 file if there are no Access 2010 specific features used.
Trans_ID is increment field as per record added (VBA Code is written for increment)is the Trans_ID "continuous" through out the table.
or will it re-start (to 1) for each Flight Number?
foreign key in SQL server.
can you remove it as foreign key (foreign key to what table/field?).
this number is generated by ms Access.
can you just test it as Int.
As discussed above Trns_ID field here it is dbo_trns!id
My Real life Scenario : MsSQL (Back End ) and Front End is (Ms Access)
below mention is a Trns Form ( Delivery Order Challan).
Main Form ( Invoice_Mast ),
Invoice_Mast!Challan_No (Primary Key)
Sub-form ( dbo_Trns)
dbo_Trns!id is Primary Key (Using Code Auto Increment)
dbo_Trns!Challan_No (Foreign Key)
View attachment 93133
edit ID of table dbo.Trns in MSSQL as Int only (don't make it as PK).