Hey got a big issue i need to resolve
if i have a table that records two distinct values entered by user.. NC001 OR TE001
Equipment_id | Serial | location
--------------------------------
NC001 |
if i have a php based form how can i tell it that if a user select NC or TE from a drop down box it automatically fills in the next field with
select MAX(`Equipment_ID`) FROM `asset_base` WHERE `Equipment_ID` LIKE '%NC%' +1
to increment the max NC upwards to add a new item without the user being able to overwrite the NC number..