Forum Discussion
DonLarson
5 years agoQrew Commander
Chris,
Yes you want to upload the spreadsheet matching the current Record ID#. The trick here is to add a column of data with the value of "1". When you import create a new field as a Check Box. Call it Temp Delete or some other variant on that.
After the import you can run a custom report where you set the filter:
[Temp Delete]=True
Then delete all the records in the report.
Poof. They are gone.
I suggest going back into the table and getting rid of the new field so that it will not cause confusion in the future.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Yes you want to upload the spreadsheet matching the current Record ID#. The trick here is to add a column of data with the value of "1". When you import create a new field as a Check Box. Call it Temp Delete or some other variant on that.
After the import you can run a custom report where you set the filter:
[Temp Delete]=True
Then delete all the records in the report.
Poof. They are gone.
I suggest going back into the table and getting rid of the new field so that it will not cause confusion in the future.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------