Hey Guys I'm a newbie programmer and looking to see if someone can help me out with a lil program I'm developing.I want to track orders for my small furniture factory.
I want to create a tracking number based on the OrderNumber+ProductID+SeriesNumber.It should look like this:
10085-88-01
The SeriesNumber is for if a product is ordered more than once then it should add 1 to the SeriesNumber.So know it should look like this:
10085-88-01
10085-88-02
That is were my problem is!How do I search my Datagrid before I add the product to check for a duplicate and if so how do I add 1 to the SeriesNumber?
Hope this isn't too complicated to do!!thanx!!