i want to create a database, purpose is user will request some items, each request they may ask 30 or more items, these items details such as itemcode, description, unit of measurement,
qty, price, they have to enter manually not from master data meaning not dropdown or selectable. but some fields like their department, their name, items category they can select from different master tables. Now my question is each request we have one reference number, and request number. these number can be different, user should not enter request number it should be auto generated number, and reference number user should enter but each request one number. how can i accomplish this target. i mean how to design for these numbers fields, what properties i need to give.