I am trying to create a database of office equipment and to whom each piece is assigned.
I have the following tables created:
1) Users
2) Equipment type
3) Equipment status (to record whether it is still in use etc)
I then created another table, Equipment Master, where I record the individual pieces of equipment and their serial numbers, with Look-Ups to select one of each of the other three table entries.
This all works fine, and I created the forms to allow me to add new entries to each of the above. But what I cannot find a way to do is to select an existing entry in the Equipment Master table and change any of the parameters, for example to indicate that a laptop has been reassigned to a different user.
Any help would be much appreciated.