Link to home
Start Free TrialLog in
Avatar of Theron Hogg
Theron Hogg

asked on

Display records based on button selected in Access 2016

I have created a seating plan in a form for my works building to manage the hosts. I'm wanting to click on a seat and have all details display in the fields at the bottom inc. who sits there, what hosts, make/model of hosts .etc. It's possible for a desk to have multiple hosts (a PC, laptop, Mac .etc), yet only 1 user can be sat there. That's why I've set up multiple record entries at the bottom so up to 3 can be shown. See attached image. User generated image Each host is associated with a user. Could I display multiple records that are associated with a userid? How could I go about this?  Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can you post your table designs and ERD
(Entity Relationship Diagram)
Solutions provided.