G
Guest
I have a number of reports (not linked to any tables or queries) that
displays terms of reference for different jobs. I would like to add a field
to these reports that adds the name of the persons to which the terms relate.
i have a query which divides these people up into there respective job
titles, and i can attach a field that adds the name to the respective terms,
however this only works if there is only one person related to that terms.
there is one set of terms where there are a number of people with the same
job title. i would like a fresh set of terms for each person on the list.
all it does at the moment is adds a list of people onto one set of terms.
how do i do this (hope i havent confused things too much)
displays terms of reference for different jobs. I would like to add a field
to these reports that adds the name of the persons to which the terms relate.
i have a query which divides these people up into there respective job
titles, and i can attach a field that adds the name to the respective terms,
however this only works if there is only one person related to that terms.
there is one set of terms where there are a number of people with the same
job title. i would like a fresh set of terms for each person on the list.
all it does at the moment is adds a list of people onto one set of terms.
how do i do this (hope i havent confused things too much)