Asset Tracking

[mm26]

Re suggestions in thread https://www.accessforums.net/databas...out-27485.html

Would you mind explaining how the dependent child tables would work? I am adding asset tracking to our employee database and will be tracking Computers, Air Cards and Cell phones (for now).


tblAsset


AssetID PK
AssetType FK (Computer, Air Card, Cell Phone)

? Confusion begins.....


thank you!!

[June7]

Might look at http://office.microsoft.com/en-us/te...001225342.aspx

[mm26]

Hi,
I downloaded MS's Asset Database and it looks like the Asset Table only has one FK (Owner), the rest of the fields are text:
Description
Category
Condition
Model
etc.

[June7]

Consider:

tblAssets
AssetID (PK)
EmpID (FK)
AssetType
ModelNo
SerialNo

tblCellDetails
AssetID (FK)

tblComputerDetails
AssetID (FK)

tblAirCardDetails
AssetID (FK)

Various fields for each Details table.

Use form/subform arrangement for data entry/edit.

[mm26]

Thank you so much, I really appreciate the help! Sorry for being a little dense!

[mm26]

Hi,
I added a subform to the employee form to display Assets associated with each employee. I can link the employee form to the asset form for additional details:

AssetF

Has Header info (Asset#, AssetType, Identifier & Employee Assigned)

Subform 1 (I would like just the appropriate detail subform but don't know how to do this**)
Suborm 2 Transactions (to show history, returned and reassigned assets)

**I am unsure how to display the detail information on this form. Is there a way to choose the appropriate table based on the asset type? For instance, I just want to display the ComputerDetailsF for Computers, the AircardF for aircards etc.

Thank you so much!!

[June7]

I suggest you use 3 subforms organized on a tab control.

[mm26]

Thank you, is there a trick to linking the correct details table? A query based on asset type maybe?

[mm26]

Hi,
I added a subform to the employee form to display Assets associated with each employee. I can link the employee form to the asset form for additional details:

AssetF

Has Header info (Asset#, AssetType, Identifier & Employee Assigned)

Subform 1 (I would like just the appropriate detail subform but don't know how to do this**)
Subform 2 Transactions (to show history, returned and reassigned assets)

**I am unsure how to display the detail information on this form. Is there a way to choose the appropriate table based on the asset type? For instance, I just want to display the ComputerDetailsF for Computers, the AircardF for aircards etc.

Thank you so much!!

[June7]

Here is a technique that will allow the 3 detail subforms to sit next to the Asset subform.

http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

If you want only one displayed at a time, it is possible to programmatically set the SourceObject of the subform container control. Or to hide or show subform containers by setting Visible property.