L
LHarris
I am looking for a database to track the keys each employee has been issued.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
issued.LHarris said:I am looking for a database to track the keys each employee has been
Very simple to build:
table of employees
table of keys
intersect or join table of the Primary Key value from each of the above with
perhaps an added date field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
L
Larry Daugherty
There are several databases templates included with Access. You can easily
modify one of the simpler ones like their Music offering to serve your
purposes.
HTH
--
-Larry-
--
modify one of the simpler ones like their Music offering to serve your
purposes.
HTH
--
-Larry-
--
issued.LHarris said:I am looking for a database to track the keys each employee has been
L
LHarris
I constucted a table for employees, but we don't have a set number of keys
and thats it. We are able to cut our own keys as the need arises. So I also
made a form, (from another table I added) to enter keys for employees. But I
am getting stuck at the point of joining the tables. I would like to click on
an employee record and view the keys assigned to the employee. I built a
relationship between the two tables, but when I click on an employee the keys
table comes up blank. I know I am doing something wrong with the
relationship, but not sure what.
and thats it. We are able to cut our own keys as the need arises. So I also
made a form, (from another table I added) to enter keys for employees. But I
am getting stuck at the point of joining the tables. I would like to click on
an employee record and view the keys assigned to the employee. I built a
relationship between the two tables, but when I click on an employee the keys
table comes up blank. I know I am doing something wrong with the
relationship, but not sure what.
L
Larry Daugherty
It still isn't absolutely clear to me how your keys play in your app. Can
more than one employee have a copy of the same key or is each key unique
within your application? It makes a huge difference in how they are recorded
and tracked.
If each key is unique in the real world then it should also be unique within
your application. If "keys" are given names or numbers but there can be
many copies with the same name or number in play in the real world then you
have to show it that way in your application . Which is it?
If keys can exist without being assigned to an employee then you don't want
a relationship between your employees and your keys.
HTH
more than one employee have a copy of the same key or is each key unique
within your application? It makes a huge difference in how they are recorded
and tracked.
If each key is unique in the real world then it should also be unique within
your application. If "keys" are given names or numbers but there can be
many copies with the same name or number in play in the real world then you
have to show it that way in your application . Which is it?
If keys can exist without being assigned to an employee then you don't want
a relationship between your employees and your keys.
HTH
L
LHarris
Many employees can have copies of the same key. We would either not enter a
key unless assigned to an employee or have a "Master List of Keys" and have
those keys not assigned to an employee assigned to Cabinet.
I have been working on the table relationships and think I am pretty close
to getting it.
key unless assigned to an employee or have a "Master List of Keys" and have
those keys not assigned to an employee assigned to Cabinet.
I have been working on the table relationships and think I am pretty close
to getting it.