Getting started

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have spent alot of time reading and trying to
understand Access and now understand it will be an on-
going process. My question is that I wish to set up a
database that will track assets (make, model etc.)by
employees. The two tables, personnel and assets somehow
dosen't seem enough. There are 15-20 items that get
reasssigned to different personnel from time to time and
I need to be able to track each asset. I know that this
is pretty basic and I have spent long hours trying to get
it up and running. If someone has some thoughts as to
how they would accomplish this it would be greatly
appreciated.
 
Hi,
You need a third table.

tblEmployee
EmployeeId
... employee details

tblAsset
AssetId
... asset details

tblAssigned
EmployeeId
AssetId
and if necessary to keep history
AssignedDate -----
RelinquishedDate -

frmAssigned is then based on tblAssigned

HTH
Marc
 
Thanks for the quick response. Is this third table the
linked table in many to many relationship? Thanks again.
 
Hi
Yes, the third table is the junction table.
tblEmployee - 1 -> many tblAssigned records
tblAsset - 1 -> many tblEmployee records (depending on the dates)

Marc
 
yes, it's the linking table. it's the "many" side of a one-to-many
relationship with tblEmployees and a one-to-many relationship with
tblAssets.
 
Marc - thanks again. On this third table, tblAssigned, I
would like to draw names from the tblPersonnel for both
the field received from and also assigned to. Showing
that the particular asset was transferred. How might I
accomplish this. Many thanks
 
Hi,
make a form based on tblAssigned. Add a combobox based on tblPersonnel, with
tblAssigned.EmployeeId as the source - the wizard should guide you through
this fine.

If you need more assistance, please post the approx table structure.
Thanks
Marc
 
Back
Top