M
Michelle
I am sure I am looking too deep into this but I have the following data and
can not figure out how to oraganize it so I don't save duplicate data.
This is for Key Traking.
The fields I have are.
Positon/Location (Job Title or Area)
Discontinued (Positon/Location no longer used)
Name (Staff Name)
Ring # (Key Ring #)
#of Keys ( # of Keys on Ring)
Storage (Storage Location)
Discontued (Storage Location no Longer Used)
Key # (Key #)
Tag # (Storage Tag of Key #)
Description (Discription of what Key Does)
Disconituned (If it has been removed from use)
As for right now I have the follwoing:
tblPositionLocation
PLID (Auto Number)
Positon\Location (Text) - No Duplicates
Discontinued (Yes\No)
tblStorage
STID (Auto Number)
Storage Area (Text)
Discontinued (Yes\No)
tblKey
Key# (Text)
Tag# (Text)
Description (Text)
Discontinuded (Yes\No)
tblUser
Name (Text)
Ring# (Number)
#ofKeys (Number)
This is how the data is stored:
Pos/Loc - Name - Ring # - # on - Key# - Tag# - Description
- Storage
Engineer - John Smith - 100 - 8 - A156 - 65 - 1.554 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - A223 - 82 - 1.663 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - B159 - 33 - 2.233 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - C156 - 58 - File Key
- MW Key Engineer - John Smith - 100 - 8 - 12589 - 26 -
Fire Box Key - MW Key
Engineer - John Smith - 100 - 8 - A758 - 88 - 6.221 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - A233 - 10 - 1.112 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - Z662 - 92 - 1.113 Door
Key - MW Key
You can have more than one name assocatied to an Positon\Location however
only one Name can be assiged to a Ring#(No Duplcate Ring#'s) However a person
can have more than one Ring3 assigned to them. The Key# - Tag# - Description
shoudl only be entered once for each key however a key can be assigned to
more than one Ring#. Storage only needs listed once however you can have
more than one thing in that storage area. (I think I may have just confued
myself even more)
This is what I would like the form to look like
Postion/Location (Drop Down)
Engineer
Name (You Enter) Ring # (Drop Down) # on Ring (Auto Fill)
John Smith 100 8
Storage Location (Drop Down)
MW Key Box
Then sub from with Key Info ( You enter the Key # and it auto fills Tag &
Descripton)
Key# Tag# Description
A156 - 65 - 1.554 Door Key
A223 - 82 - 1.663 Door Key
B159 - 33 - 2.233 Door Key
C156 - 58 - File Key
12589 - 26 - Fire Box Key
A758 - 88 - 6.221 Door Key
A233 - 10 - 1.112 Door Key
Z662 - 92 - 1.113 Door Key
can not figure out how to oraganize it so I don't save duplicate data.
This is for Key Traking.
The fields I have are.
Positon/Location (Job Title or Area)
Discontinued (Positon/Location no longer used)
Name (Staff Name)
Ring # (Key Ring #)
#of Keys ( # of Keys on Ring)
Storage (Storage Location)
Discontued (Storage Location no Longer Used)
Key # (Key #)
Tag # (Storage Tag of Key #)
Description (Discription of what Key Does)
Disconituned (If it has been removed from use)
As for right now I have the follwoing:
tblPositionLocation
PLID (Auto Number)
Positon\Location (Text) - No Duplicates
Discontinued (Yes\No)
tblStorage
STID (Auto Number)
Storage Area (Text)
Discontinued (Yes\No)
tblKey
Key# (Text)
Tag# (Text)
Description (Text)
Discontinuded (Yes\No)
tblUser
Name (Text)
Ring# (Number)
#ofKeys (Number)
This is how the data is stored:
Pos/Loc - Name - Ring # - # on - Key# - Tag# - Description
- Storage
Engineer - John Smith - 100 - 8 - A156 - 65 - 1.554 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - A223 - 82 - 1.663 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - B159 - 33 - 2.233 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - C156 - 58 - File Key
- MW Key Engineer - John Smith - 100 - 8 - 12589 - 26 -
Fire Box Key - MW Key
Engineer - John Smith - 100 - 8 - A758 - 88 - 6.221 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - A233 - 10 - 1.112 Door
Key - MW Key
Engineer - John Smith - 100 - 8 - Z662 - 92 - 1.113 Door
Key - MW Key
You can have more than one name assocatied to an Positon\Location however
only one Name can be assiged to a Ring#(No Duplcate Ring#'s) However a person
can have more than one Ring3 assigned to them. The Key# - Tag# - Description
shoudl only be entered once for each key however a key can be assigned to
more than one Ring#. Storage only needs listed once however you can have
more than one thing in that storage area. (I think I may have just confued
myself even more)
This is what I would like the form to look like
Postion/Location (Drop Down)
Engineer
Name (You Enter) Ring # (Drop Down) # on Ring (Auto Fill)
John Smith 100 8
Storage Location (Drop Down)
MW Key Box
Then sub from with Key Info ( You enter the Key # and it auto fills Tag &
Descripton)
Key# Tag# Description
A156 - 65 - 1.554 Door Key
A223 - 82 - 1.663 Door Key
B159 - 33 - 2.233 Door Key
C156 - 58 - File Key
12589 - 26 - Fire Box Key
A758 - 88 - 6.221 Door Key
A233 - 10 - 1.112 Door Key
Z662 - 92 - 1.113 Door Key