J
Joe
Please can you help? I am trying to monitor the relocation of an asset to a
different employee or to a different department. So far I have the following
tables-
TblAssets
AssetsID (autonum, PK)
AssetDescription (txt)
EmployeeID (number, FK)
DepartmentID (Number, FK)
Make (txt)
Model (txt)
SerialNumber (txt)
TblDepartments
DepartmentID (Autonum, PK)
DepartmentName (txt)
TblEmployees
EmployeeID (Autonum, PK)
FirstName (txt)
LastName (txt)
TblTransaction
MoveAssetID (Autonum, PK)
MoveAssetDescription (txt)
AssetID (number, FK)
EmployeeID (number, FK)
DepartmentID (number, FK)
FromDept (txt)
ToDept (txt)
FromEmployee (txt)
ToEmployee (txt)
TransactionDate (Date/time)
Relationships are set so that there are one-many links between TblAssets and
TblDepartments on DepartmentID; TblAssests and TblEmployees on EmployeeID;
TblAssets and TblTransaction on AssetID.
Main form frmAssets has comboboxes for Employee and Department fields and
contains a tabbed subform frmTransaction which displays the fields
MoveAssetID, TransactionDate, MoveAssetDescription, FromDept, ToDept,
FromEmployee, and ToEmployee in datasheet view.
I have set FrmAssets so that if the Employee selected in combobox for asset
#1 is changed to a different employee then a form frmAssetMovtEmployee is
called requesting selection of options via combo boxes for
MoveAssetDescription, FromEmployee and ToEmployee. This is accomplished by
calling a macro to open the form using OnChange event. The same has been
done for frmAssetMovtDepartment.
The data changes are being recorded accurately in TblTransaction except for
the asset number and I just don’t seem to be able to get data to echo in the
subform frmTransaction. I’m sure I am missing something simple here but just
can’t see it. Your help is very much appreciated.
Joe
different employee or to a different department. So far I have the following
tables-
TblAssets
AssetsID (autonum, PK)
AssetDescription (txt)
EmployeeID (number, FK)
DepartmentID (Number, FK)
Make (txt)
Model (txt)
SerialNumber (txt)
TblDepartments
DepartmentID (Autonum, PK)
DepartmentName (txt)
TblEmployees
EmployeeID (Autonum, PK)
FirstName (txt)
LastName (txt)
TblTransaction
MoveAssetID (Autonum, PK)
MoveAssetDescription (txt)
AssetID (number, FK)
EmployeeID (number, FK)
DepartmentID (number, FK)
FromDept (txt)
ToDept (txt)
FromEmployee (txt)
ToEmployee (txt)
TransactionDate (Date/time)
Relationships are set so that there are one-many links between TblAssets and
TblDepartments on DepartmentID; TblAssests and TblEmployees on EmployeeID;
TblAssets and TblTransaction on AssetID.
Main form frmAssets has comboboxes for Employee and Department fields and
contains a tabbed subform frmTransaction which displays the fields
MoveAssetID, TransactionDate, MoveAssetDescription, FromDept, ToDept,
FromEmployee, and ToEmployee in datasheet view.
I have set FrmAssets so that if the Employee selected in combobox for asset
#1 is changed to a different employee then a form frmAssetMovtEmployee is
called requesting selection of options via combo boxes for
MoveAssetDescription, FromEmployee and ToEmployee. This is accomplished by
calling a macro to open the form using OnChange event. The same has been
done for frmAssetMovtDepartment.
The data changes are being recorded accurately in TblTransaction except for
the asset number and I just don’t seem to be able to get data to echo in the
subform frmTransaction. I’m sure I am missing something simple here but just
can’t see it. Your help is very much appreciated.
Joe