Hello everyone. I decided to post because I'm an Access newbie and didn't know how to properly phrase my problem as search terms.
I have a database that has two tables. One contains a list of facilities, the other a list of work orders, date, hours, activity, and a drop down to choose the facility. There is also a form that lets the user enter all the data about the work order, and in that form the drop down correctly shows the entire building list.
I need a report that the user can run that will show the following: the work order, facility, B/U, date, activity, and hours, with B/U, work order, and facility being the three grouping levels.
I made a report, using the wizard, and it returns the results I need...except that it's using the unique ID from the building table instead of the building name. I changed the relationship, but that didn't fix it. I tried changing the control source and got back "#Error" for my trouble. Attached are two screen shots: the first of the tables, the form, and the report, the second of the relationship layout.
A copy of the database, less a few tidbits of semi-proprietary data can be made available if need be.
Tables, Form, and Report:
Relationships:
Any help (even a "Read section X of the help file you dummy!") is most appreciated.