linking table

[robert]

I would like to keep track of the transfers of assets
between employees.
tblEmployee (one to many with tblHistory)
EmployeeID
FirstName
LastName
tblAsset (one to many with tblHistory)
AssetID
AssetDescription
tblHistory (linking)
EmployeeID
AssetID
DateOfTransfer
Have I set tblHistory up correctly? the 'many side' to
tblEmployee and the'many side' to tblAsset? I have
struggled with this but it doesn't work properly.
I read a similar post and thought I had it worked out,
but still having problems. Gott'a be doing something
wrong. Your help is greatly appreciated. Thanks in
advance.

 

[John Vinson]

I would like to keep track of the transfers of assets
between employees.
tblEmployee (one to many with tblHistory)
EmployeeID
FirstName
LastName
tblAsset (one to many with tblHistory)
AssetID
AssetDescription
tblHistory (linking)
EmployeeID
AssetID
DateOfTransfer
Have I set tblHistory up correctly? the 'many side' to
tblEmployee and the'many side' to tblAsset? I have
struggled with this but it doesn't work properly.
I read a similar post and thought I had it worked out,
but still having problems. Gott'a be doing something
wrong. Your help is greatly appreciated. Thanks in
advance.

The only thing I might add is to use two dates - DateAquired and
DateDisposed. DateOfTransfer is ambiguous - does it mean the date the
person got the asset or the date they transferred it to someone else?

If you could describe a) the Form you're using to interact with this
data (table datasheets will NOT be useful here!!!) and b) the problems
that you're having, we'd be glad to try to help.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps