So i have 3 tables in my DB, Estate, Room and Item
Every estate has multiple rooms, each room has multiple items.
I have made acceptable data entry forms for my employees using split forms/nested data sheets.
I have record navigation button that switched the estate the user is viewing.
I want a button to create a report for the estate at hand. This report will show the items in the estate, grouped by room.
I have the report showing what i want, pulling data from the tables directly, but the problem is that it is reporting on all estates - not just the active one.
How can i do this? I am trying to keep this as user friendly (least amount of typing/ideally just a single button) as possible.
Thanks in advance.