Question Locked

Access 2003 Asset Tracking database help

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to add a software table to the Asset Tracker database I dowloaded from Microsoft that should contain software version, key and cost fields that will be linked to a specific asset. In other words I want to enter a specific asset (laptop, desktop) that will be assigned to an employee and it has an x number of programs on it and I can enter their keys and cost. I am not sure the best way to link the tables.

Any help is greatly appreciated.

3 replies

by scontiu

I would create a table called software with the software fields you need and have a one to many relationship with the "asset" table.

by Wizard57M-TR

it's doubtful that after almost 4 years the person asking this question
is still looking for the answer..

This discussion is closed to new replies.