Pherical tracking on workstations

Stingfish

Registered User.
Local time
Tomorrow, 06:38
Joined
Jul 29, 2003
Messages
24
Im trying to design a tracking DB for phericals and ports located at workstations throughout the office. Theres over 200 workstations.

Ok this is what I have so far. Please tell me if im on the right track and any suggestions.

Ive never been good at doing the relationships. They are so frustrating at times.
 

Attachments

Last edited:
Not sure but:
Parent (P)
Child (C)

"Subsection" is P to "CostCenter" C
"CostCenter" is P to "Employee" C
"Employee" is P to "Workstation" C
"Workstation" is P to "Equipmentuse" C
"Equipment" is P to "Equipmentuse" C

Cost Center number is already a unigue number no need for Autonumber.
Pass number a unique field no need for Stafffid
 

Users who are viewing this thread

Back
Top Bottom