I do apologise if I make a hash of explaining this
I have made a few changes to the asset management template and its basically what we need to track assets at work.
I have approx 1220 clients and 1600 items of equipment.
Some clients will have more than one peice/type.
I currently have this data in excel sheets for each type of equipment.
The rows have the clients details then the equipment.
Access has 2 tables - clients and Assets.
The assets list form has an 'owner' field that is populated from the contacts extended query and I assume links the data?
As you can tell I am not enamoured at the prospect of going through 1220 people and matching them to their equipment.
Is there any way on earth to (easily as I am a bit of a dunce with this) upload the data so that stays linked?
I have made a few changes to the asset management template and its basically what we need to track assets at work.
I have approx 1220 clients and 1600 items of equipment.
Some clients will have more than one peice/type.
I currently have this data in excel sheets for each type of equipment.
The rows have the clients details then the equipment.
Access has 2 tables - clients and Assets.
The assets list form has an 'owner' field that is populated from the contacts extended query and I assume links the data?
As you can tell I am not enamoured at the prospect of going through 1220 people and matching them to their equipment.
Is there any way on earth to (easily as I am a bit of a dunce with this) upload the data so that stays linked?