I am a beginner, using Access 2007.  I am trying to create a network documentation database to track desktops, printers, switches, etc.  I am trying to setup the tables and not sure how to setup a field or multiple fields to show the current location of an asset, along with all previous locations (building, room and jack numbers including dates associated with the former locations).  What is your recommendation?

V/R

M

---

Answer from Richard Rost:

This would be a two-table setup. You have the primary table for the asset, and then a second, related table to show the history of the asset. The history item with the most recent date would be the current location of the asset.

It sounds to me like you need to learn a little more about the basic concepts of building a Relational Database, and making relationships between two tables.

Watch this free tutorial on my web site for help with this topic:

http://599cd.com/tips/access/relational-tables?key=BlFAlEx

I also spend a whole hour in my Access 201 class going over table relationships:

http://599cd.com/site/access/access201?key=BlFAlEx