Hi,
Thank you for reply.
>>1. Stay away from using user data as Primary key, you will be better off doing that as a rule of thump.
I am using auto increase number as PK, MBarCodeID
>>2. I'd have 2 tables, one called Items which has Serial No,Matrix(Logical),
Primary key and another called Item_details which has Primary key, Foreign Key (Serial
No.),Color,Size,Qty & OutletID.
Hmmm... can you explain further? Do you meant serial no and matrix item will be in same table? For your info, serialno item is unique regardless of colour and size, instead matrix would. Could you please layout the table structure?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
