Problems with reports

[Joe]

I have created my first database. I have a table called
project which has various information about projects
(naturally) and amonst other things it has three columns,
which index into another table called people, which
contains information about people involved with projects.

Becasue I have three references from the Project table
into the people table, I seem to have a problem getting
the report to lookup the people and give me the name
(rather than the reference).

Everything works fine in the simpler reference into the
tables status or risk_level, where there is a single
reference from the project table into these other tables.

What should I do to get around this problem, or have I
missed the point? If I were using a probber database I
would simply be doing the SQL to get the lookup, but then
I'd be codeing the report by hand...

Joe

 

[Pavel Romashkin]

Base the report on a query that will link the Projects table with People
table, and make sure that the query displays people's names. Link the
tables on PersonID.

Good luck,
Pavel