i have 4 fields at DB.i set them become cant duplicate entry.They are:
1. Model Varchar(14) Unique
2. Serial varchar(8) Unique
3. Lot varchar(5) Unique
4. Line char(5) Unique
Model Serial Lot Line
First data remocon x0001 033a fa 01
and if i have inputed same data it can't recorded.
remocon x0001 033a fa 01
but how to make this data success to input if i type like:
remocon x0002 033a fa 01
and i want the result like:
Model Serial Lot Line
remocon x0001 033a fa 01
remocon x0002 033a fa 01