Database Filtering Follow

Katie Anderson

I am working in the database filter (if there is a better way, I am totally open to suggestions). If there are multiple records with the same Link Code (one database field), then I need to only print the record with the lowest Batch Seq (another database field). Is that possible to do?

My goal here is to only print one record per Main Link, which would be the record with the lowest batch number, however I can make that work.

For example: in my database there are 18 records. It should only print records on lines 2, 4, 7


Record picker would work in small instances (like this one), but there are some Main Links that have 100s of items to un-select. 

Please sign in to leave a comment.