"Update Matching Records"..why is this option duplicating imported records?

[parasko]

Hi all,

In my student database, I wish to regularly add new students but also update the current student records.

As I import the Excel file which contains the relevant information, I choose the option

'update matching records in found set' and I tick 'Add remaining data as new records'.

In the field mapping section, I choose the Student ID field (which is a unique field) as

=Match records based on this field

These options should all be correct for the purpose of updating existing records and adding any new records.

However, instead, this import adds new records each time. So in effect, I end up with a duplicate record of existing records.

What am I doing wrong here?

[LaRetta]

Are you remembering to Show All Records first?

[IdealData]

The import works on the CURRENT FOUND SET, which can be different to ALL RECORDS, as you have interpreted.

[parasko]

Thanks.

I will try 'Show all Records' to see if it makes a difference.

[parasko]

Are you remembering to Show All Records first?

Doh!

Thanks LaRetta...problem solved