Relationship Problem

[scarnie]

Is it possible to have two seperate relationships to a table and could I then generate a report using one of these relationships? The reason I ask is I am having a problem with a report I have created which uses info from two tables. There is already an existing relationship between these tables but when I add another field to the relationship it works but other related information doesn't?

Thanks in advance.

[RalphL]

You need to make another TO for one of the tables and make the new relationship to this TO. Then the 2 relationships are different. If you make 2 relationships between the same 2 TO's they ADD meaning both conditions must be met for a relationship to exist.