I'm a novice using trying to develop an internal database that stores all of the vendors we use. I've developed forms for our users to rate interactions with each company so I have the following tables:
Vendor table: Vendor ID, various identifying information about each vendor, e.g. address, phone, etc...
Vendor rating table: Linked to vendor table by Vendor ID, with ability to enter a rating and description of each interaction
I've created a report in the form of a pivot table to report the average rating for each vendor.
I've created a form that is grouped by vendor and nested within that, shows the rating-level detail with descriptions of interactions.
However, I can't seem to combine the two together so that the user can see both the average rating as well as the rating detail on a single screen.
Please help. What additional information can I provide??