Just a quick question.
I need to create a table which will be heavily used every day by more than 100 users.
Table will have Document No. and Task No. as major fields
Should I create a table with 2 fields as primary key or 1 field
Table 1 (primary key on 2 columns)
Document No. Task No.(must be code data type)
which one will you prefer. of-course I will have document no. in table 2 as well but not part of primary key.