G
Gene
I have an Inventory Form where I use a lookup table field to add the User.
The User Lookup Table is linked to a User Detail Information table that I am
using as a subform with the Inventory Form.
If I have a piece of hardware, such as a monitor assigned to the User "Tom"
I want Tom's Detail Infomation displayed in the subform. This works if I add
the data through the tables, but when I change the User in the main Inventory
form to User "Jane" the detail record stays the same instead of showing
Jane's Detail Information.
What is the best way to get this done? This database is in the infancy
stages so that I learn/relearn the proper way to use access on a larger scale.
The User Lookup Table is linked to a User Detail Information table that I am
using as a subform with the Inventory Form.
If I have a piece of hardware, such as a monitor assigned to the User "Tom"
I want Tom's Detail Infomation displayed in the subform. This works if I add
the data through the tables, but when I change the User in the main Inventory
form to User "Jane" the detail record stays the same instead of showing
Jane's Detail Information.
What is the best way to get this done? This database is in the infancy
stages so that I learn/relearn the proper way to use access on a larger scale.