Hi Jim,
You need a linking Table to associate the Reports and
the Persons. It must contain, in each record, the
ReportID and the Associated Person ID, so you will
have one record for each Report/Person combination
that you ship. It is a Many to Many link.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@...> wrote:
>
> Hello all,
>
> I am building a reference database for reports that go to Directors and Supervisors. It is becoming more of a documentation database than just a database for reports to people.
>
> There are 5 databases that reports are generated from that go out to these people. But I am trying to think this through on a logical plane but it is my last day before my vacation and I am struggling with the relation link between the two tables. Below is what I have right now. But I think that if there is a many to many between the person table and the report table how would I work this. Because many people can get the same report. Obviously there are more tables for macros, modules and queries as seen in the tblDatabase table.
>
> Thank You
>
> Jim Wagner
>
>
> I have a table with all the people
> tblPerson
>
> PersonID PK
> PersonName
> EmailAddress
>
>
> A table for reports
> tblReports
>
> DatabaseID FK
> ReportID PK
> ReportName
>
> Another table
> tblDatabase
>
> DatabaseID
> DatabaseName
> ReportID
> QueryID
> ModuleID
> MacroID
>
Tidak ada komentar:
Posting Komentar