ValueListItems function not working
I made a value list "Serial#'s" that uses values from field Serial# so if a new serial number is made it will be updated in value list Serial#'s. I then made a field called LIstedSerial that has a calculated value of
ValueListItems ( GetField ( PurchaseOrders 2::Serial# ) ; "Serial#'s" )
The purpose of this is when I have multiple serial #'s that are the same, instead of it being listed 8001,8001,8001,8001,8002 it will only display 8001,8002 on the layout. Did I perhaps use the wrong GET function?