caveat: I am learning access and this is my first usenet post ever. if
there is a more appropriate place for my questions, please let me
know.
I have created a grants management database and am now trying to
create reports. The report starts with general info such as the grant
name, accounting code etc. This part is done.
Now I am trying to list the names and contact information for all
grant officials. These are stored in a table "person" which is joined
(1 to many) to "grantcontactdetails" which is joined (many to 1) to
"grantid"
I need the report to list all the names that pertain to a specific
grant.
My questions?
How do I set up the record source to accomplish this?
Does this need to be done in a sub report? if so why?
Any other tips for a newbie.
Any advice on online reports tutorials, articles or books would be
great. I have read a intro to db development book and am working from
"how to do everything with ms acccess 2003" by V. Anderson.
Thanks,
Jean-Paul