Bidirectional relationship

[ukare1996]

Hi all,

I have two tables with a many to one (*:1) relationship.

Table 1: main data table

table 2: Dates table (Many)

Creating a single directional relationhip means I can't filter data from the main using slicers with data from the Visit Dates

Creating a both directional relationship allows me to filter by the visit dates table however, it is omitting data.

How can I resolve this?

Any help would be much appreciated.

Thanks in advance

[lbendlin]

Creating a single directional relationhip means I can't filter data from the main using slicers with data from the Visit Dates

Do you have a valid business reason for that need?  If yes, then accept the slight blemish on the data model.  The data model needs to follow the business problem, not the other way round.