Make a table

[Arunoday]

Sir i want to design a table where i need to store the data of individual
with their clothing details.
Suppose a employee is issued 50 types of different clothes after specific
durabiility of that particular clothes. like if i issue a overall to a
employee, the table should contain the details with these fields:-
EmpID
ItemNo
ItemDescription
QtyIssued
dateIssued
ItemLIfe
NextDueDate
Here no fields are the unique fields because the same item can be issued
several times to particular individual..
now the point is if i want to issue 50 different clothes with the same fields
(ItemNo, ItemDescription, QtyIssued, DateIssued, ItemLIfe, NextDueDate) in
res[pect of the single individual the total field no. will be 250, and it is
really a heavy for for designed form to enter a data.

so sir, can u suggest me the easiest way to make a table with few fields.
here i need to store as well as retrieve the data from the table for future
use. where i can issue particular item after the expiry date of particular
item showed in the NextDueDate field..

 

[Pat Hartman]

Create a table where you will store the employee information, another to
hold information on the clothing items, and the third table is a relation
table to associate clothing with an individual.
tblEmployee:
EmployeeID
FirstName
LastName
....
tblItem:
ItemID
ItemDescription
ItemLife
.....
tblEmployeeItems:
EmployeeItemsID
EmployeeID (foreign key to tblEmployee)
ItemID (foreign key to tblItem)
DateIssued
QtyIssued
NextDueDate
.....

With this structure you have 1 row for each employee in tblEmployee, you
have 1 row for each item in tblItem, and you have many rows in
tblEmployeeItems that make the list of items assigned to a specific
individual.