Uniform Assignment and Inventory

[Akilez]

I am trying to make a uniform inventory and assignment database. The problem
is in trying to get the Shirts.Assignedto field to update when I use the
lookup on the Employee table. I know I missing something obvious.

I have tables for:
Employee
Code Text (PK)
Name Text
Shirt (lookup to Shirts.size)(I want this to display and be able
to display and choose sizes from available shirts in inventory)
.... ...ad nauseum

Shirts
Number Autonumber (PK)
Size Text (lookup to Sizes)
Assignedto Text (lookup to Employee.Code)

Sizes
Size Text (PK)

 

[Klatuu]

You design needs some restrucuring:

Employee
Code Text (PK)
Name Text
ShirtSize Text (lookup to Shirts.size)
ShirtIssued Numeric Long

Shirts
Number Autonumber (PK)
Size Text (lookup to Sizes)
Assigned Y/N

Sizes
Size Text (PK)