Getting started

[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.

 

[Marc]

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

 

[Guest]

Thanks for the quick response. Is this third table the
linked table in many to many relationship? Thanks again.

 

[Marc]

Hi
Yes, the third table is the junction table.
tblEmployee - 1 -> many tblAssigned records
tblAsset - 1 -> many tblEmployee records (depending on the dates)

Marc

 

[tina]

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.

 

[Guest]

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

 

[Marc]

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