Advice on managing product serial numbers in Webforms

This may be outside of the abilities of this forum since I'm unsure how well I'll be able to describe the challenge I'm facing but here it goes...
I have a webapp (ASP.net VB, SQL DB) that I'm developing for my employer to manage product return, rework and modification requests from our customers.  We currently use a third party MRP system to manage much of our production operations but their RMA module leaves much to be desired and definitely doesn't meet the requirements of our RMA process.  I do have access to the SQL database but not the code of their GUI.  In the database they store serial numbers for all serialized assemblies and subassemblies we manufacture.  It is a pretty simple table consisting of a Part number, serial number and work order number.  I've already pulled the existing data into a view in my apps db to be able to access the information.  I don't need to utilize the work order number so I'm just pulling in the part ...