November 30, 200421 yr 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.
November 30, 200421 yr 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.
Create an account or sign in to comment