[jeanny88]

Hey guys, I really need ur help to solve my problem.. I really dun have idea how to do it. First of all, I m working using VS 2008 VB and SQL Server 2005

I m creating a web base application which record the PO plus the serial number(this is the main point). I have been created 4 table for my project. Those are customer table, branch table, product table and order table. Product are based on customer and branch.. Some of product might order by more than one branches with different serial number on the item.

In the order page I have 3 cascade drop down list which are customer, branch and product..from those 3 only related customer and product order's detail are showing out. Now I want make the column of start serial number are automated which is last serial number plus 1. So in where I could write the script?? In sql server or in vb itself, and how to write it? First I need to match all those 3 selected value in drop down list then just can calculate the starting serial number for the new entry. I m using List View for insert and viewing the data..

Any suggestion will be appreciated… hope someone will guide me to solve the problem. Thx..

[Yeroon]

Please post any code that you might already have. I think I know what you mean, but can be more sure of that if you post some code. Please post the code that fills the 3 lists and post a sample of how the serial number would have to look.

If you dont mind, please also post any queries you have.