Import External Data
 

I am using the "Import External Data" ~ "New Database Query" to create a
spreadsheet. The user would like to add 2 columns to the spreadsheet to add
information about the record. I know I can add two columns in the query in
the database, but the user would rather not do that so they have freedom to
manipulate the spreadsheet as they see fit. I have the spreadsheet set up to
"update" when the file is opened. Problem is, if there is a new record, and
say there is information for a record in the "new created columns" will stay
in the same row. For example,

Before update:

Row 10 may have information in the 2 columns.

After update:

A new record appears on line 6. Therefore Row 10 now becomes row 11, but
the information in the "new created columns" stays in Row 10.

So in effect, the "new created columns" does not stay with the correct
record.

Is there a way to keep the information with the correct records after updates.

Thank you in advance for your help. Hope this makes sense......