Fred Y
Sep 06, 2017Iron Contributor
Is it possible to filter a lookup column using a specific criteria?
I have the following lists with a lookup column that has more than 5,000 items: Purchase Orders list PO Number - text Status - Active or Closed Invoices list PO Number - lookup colum...
- Sep 07, 2017
Not a fix for the 5000 items issue, but an alternative to your current solution.
Can I assume that Purchase Orders and Invoices are not being changed ever, when the Purchase Order has status Closed? (I assume that)!
Move all Purchase Orders and Invoices into archive lists - Purchase Order Archive and Invoice Archive - thus keeping your active lists item count lower, hopefully below the limit.
Kind regards
John