|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 4th, 2008, 11:46 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Uniform Assignment and Inventory
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) 
|
|
#2
March 4th, 2008, 05:46 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Uniform Assignment and Inventory
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) -- Dave Hargis, Microsoft Access MVP "Akilez" wrote: 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)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
