Forum Discussion
SevsBo
Responsive Resident
Responsive ResidentCannot create single direction one-to-one relationship
I have created a relationship between a generic Date table and a table that containst a Date column. The relationship is identified as one-to-one, given that the date data is quite short and distinct...
danextian
Super User
Super UserHi SevsBo
If each table has a distinct set of unique dates, then a many-to-many relationship isn't necessary. To set the cross-filter direction to single, use either a one-to-many or many-to-one relationship. Dragging the relationship from Table1 to Table2 will create a flow in that direction.
SevsBoResponsive Resident
Responsive ResidentThat's exactly what I did but ended up in this situation. It will not allow a single direction relationship, only Both.
- MattiaFratello
