HI, I am developing a Inventory Management Databse in PHP/MySQL.
There are 3 fields
1. Item_Code
2. Serial_No
3. Quantity
For Example:
if Item_Code is fan02
and quantity 10
then each item quantity have a unique serial no.
How i can develop a form for user,
Who can insert item_code
then serial no. depending on quantity.
if quantity 10 then need to insert 10serail number for each part.