Forum Discussion
Related function not returning any values.
if you are creating a column in the table on the 1 side of the relationship, and getting data from the table on the many side of the relationship, you need to use relatedtable.
if you are creating a column in the table on the many side of the relationship, and getting data from the table on the one side of the relationship, you need to use related.( keep in mind, that relatedtable returns a table not a scalar value, so in order to get data from using relatedtable,
you need to then using an iterator over relatedtable . )
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
if you are creating a column in the table on the 1 side of the relationship, and getting data from the table on the many side of the relationship, you need to use relatedtable.
if you are creating a column in the table on the many side of the relationship, and getting data from the table on the one side of the relationship, you need to use related.
( keep in mind, that relatedtable returns a table not a scalar value, so in order to get data from using relatedtable,
you need to then using an iterator over relatedtable . )
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
This worked! I used the relatedtable as a variable as follows: