Forum Discussion

BobJordan's avatar
BobJordan
Qrew Cadet
7 years ago

How do I delete a sub-set of records from a connected table?

I have a large number of records that I've imported into a table over a long period of time via the connected tables option (with the add, update, but do not remove option set) and now no longer need ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
You cannot add or delete records manually on a connected table.

So your choices are to either change the source table (if that is possible) and delete them there or to adjust the filter. For example, if you change the filter to match the source records exactly, and filter the old records out, then the old records should delete. In the next refresh.
BobJordan's avatar
BobJordan
Qrew Cadet
7 years ago
Hmm, ok so a little extra work may be needed here. 

My understanding is that QB sync operations are limited to ~25MB files though correct? If I re-compile all the data I need manually into a single csv, it comes out to ~40MB.

So I suppose what I could do is:
1. split the csv into 2 files
2. sync the first file with the "add, update, and remove" setting selected in order to match the csv exactly
3. sync the second file with the "add, update, but do not remove" setting selected

Can you see any problems arising with that approach? I really don't want to mess anything up in the database and wiping all the newer records makes me a bit nervous.

Thanks for the reply!