Asset Tracking

[Jay1]

Hi,

I have a task of managing hardware assets like desktop, monitor, HDD, routers etc. Each item is marked with a unique ID.
These items could be transferred from one city to another city; so need to track that too.

1. There will be two tables
One (say AssetDetail) will have the following fields
RecordID
City
AssetID
Description of the asset (desktop/monitor etc)
ProductSerialNumber of the asset

Second (say AssetTransfer) will have the additional fields
NewCity
AssetTransferredDate

2. I only want to open a single form :
a) where on the basis of either AssetID or the ProductSerialNumber, I could open a particular record and edit it.

i) if the asset is transferred from city A to city B; then the "City" field value in AssetDetail table should change to "city B"(New City field value).

ii) At the same time, each asset transfer record should get appended to the AssetTransfer table even if the table has an existing record with the same AssetID or ProductSerialNumber.

3. Also need an option to make a new entry to the AssetDetail table from the above mentioned single form.

Can anyone help me with a sample database for the same.

J.

 

[Uncle Gizmo]

>>>Can anyone help me with a sample database for the same<<<

Have a look at this link:- http://www.databaseanswers.org/data_models/index.htm

Several Asset tracking db's marked "3" on the left hand side.

It's a web page so you can search it with Ctrl F ... I found 10 "Asset" matches...

 

[Uncle Gizmo]

I see this one:-

Assets and Locations

Could be a good start!

 

[Jay1]

This helps but I'm quite new to Access; so if a sample database file could be available that would really help me to understand the workings better.

J.

 

[Uncle Gizmo]

I see this one:-

Assets and Locations

Could be a good start!

>>>so if a sample database file could be available<<<

If you go to the link above you will see it says:-

An Access Database is available on demand.

Click on the link to get a copy....