Forum Discussion
One to One relationship issue
I have two tables with a one to one relationship - as shown below
In the table visual it appears as below with both directional flow, no option to select single.
My requirement is to display it as below, thanks in advance.
Hi Libin7963 This is perfectly Working for me. I have one to one relationship with both direction. Releation between Reference column to Reference Column. Make sure you have selected correct column for this relationship.
You have selected Product ID as a relationship column, that's why you are not getting correct result.See Image Below (Using Reference Column):
See Image below (Using Product ID Column):Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
2 Replies
Hi Libin7963 This is perfectly Working for me. I have one to one relationship with both direction. Releation between Reference column to Reference Column. Make sure you have selected correct column for this relationship.
You have selected Product ID as a relationship column, that's why you are not getting correct result.See Image Below (Using Reference Column):
See Image below (Using Product ID Column):Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
That is often a hint for you to consider combining these tables into one.
