First my table structure.
The main table "tblProcessSignoff" stores my core data. the table "Tblprocesssignofflog" stores a log of when someone signsoff on the process. and the table "tblRequiredsignofflist" stores the list of all the groups required to signoff on that request.
Here is my problem... The report that is pulled right now, is pulled with all of this data in one table. The data that is needed is first form the core table. Then i need the following columns to be a list of group names from the tblProcessGroupsList. Then the field values will be one of 3 options. If the group is required for that signoff it has no value if it is not complete yet, or has the specific value from the log table. If it is not required it has "N/A". I have done lots of looking around but have found nothing. Any help would be appreciated.