Autonumber in a Union query?

[SteveGr]

Hi all,
I have two linked spreadsheets from Excel. I have a Union Query that combines the two. Is there any way to have an Autonumber column to create a unique field? The unique field I need is required to get records from a multicolumn combo box.

Thanks, Steve

 

[pdx_man]

Not dynamically, no. And I really don't think you would really want to, either. 'cause the relationship between the Autonumber field and the rest of the records could change, say, if the user sorted them. Or, lets say a record was added to the middle of the recordset in XL ... what had an ID yesterday of 548 would today have an ID of 549. Try to devise a scheme in XL to create unique record IDs.