I have a database called xref.accdb
Linked Table name : tblXrefInfo_Extra
What I need:
In the Linked Table "tblXrefInfo_Extra" I need to go to the very last record and get the number that is there.
Then once I know what that number is.
Create a number sequence in the "Xref" Table: In the field: "XrefId"
for all those records.