Hi friends...
I'm doing Inventory Project...
I'm Having purchase and sales tables...
In purchase table fields are Code, Category, Brand,S.p, Date etc.,
Men, Women, Kids, Accessories are the VALUES STORED IN Category Fields...
In PURCHASE FORM, When i select MEN in Combobox, it has to AUTOMATICALLY allocate(SHOW) CODE(it is also COMBOBOX) numbers from 1-200, women form 201-400, kids from 401-600, Accessories from 601-1600.
No other numbers to be allocated to SPECIFIED VALUE...
i.e for MEN NUMBERS LIKE 225, 555 888 SHOULD not to be allocated...
I.e In Purchase table, i have to Generate Numbers Automatically...
Please help me...
Thanks in advance...