Hi
I am building an access database from scratch, to be used for asset tracking. I tried to use the asset tracking template to do this, but every time I changed something, it would break the database. So I'm building it from scratch. Here's how I have it set up:
I have an "Assets" table, which includes the AssetTagNumber, Model, and AssignedUser fields. I have another "Users" table, which has an AssignedUser field and a Department field.
I want to be able to use a form to select a user from the users table, and then view all the assets assigned to them. I read online about one-to-many relationships where I can link one user to multiple different assets. Which fields in the tables should I set this relationship for? And how do I then create a subform that will allow me to select a user's name from the "Users" table and view all the assets that they have assigned to them?
I already have a form that can insert a new asset and a new user, but these forms are not linked together.
My knowledge of access is basic, I am self-teaching myself everything. I have only been at this for a few days.
Thank you for any help!!