I've set up a database in MySQL to track Change Orders (Field #1) for engineered products by Serial Number (Field #2). Each product is custom designed, so more that one Change Order will likely be issued for each Serial Number. How can I get MySQL to retrieve the next sequential Change Order number for a given Serial Number when I input the Serial Number? It seems like I may have to do some type of scripting. But if there is an easier way, I'm all for it.