Manipulating Master-Detail Relationships

[wlau69]

Within Report Studio, other than the usual "Master Detail Relationships" interface, is there another way to view and modify the relationship?  Is there a way to create a conditional Master-Detail relationship?

I have 2 queries, one's the master and the other's the detail.  Using the "Master Detail Relationships" interface, I am joining these two queries with one relationship.  I would like to create a one to many relationship therefore I created a relationship where one column in the master is pointing to 2 columns over on the detail side.  The problem is that the relationship is very rigid and it requires that the 2 columns on the detail side to be of the same value.  These relationship is similar to any logic using an "AND" operator as oppose to an "OR' operator. 

[BIsrik]

then, i feel you need to have values of both the columns in a single column..in other words, union of both columns..