It'll work as long as bigger PK means "later" record. If tables has date/datetime of transaction I would rely on that field rather than PK. If table doesn't have date/datetime, I would add it and use it to determine the latest record.