Hi, I am using Allen Browne's function to try and concatenate values from a related record in a form. However, the concatenated field is not working properly.
This is the table
So I need 20FUN02 - JCM, ICFO. In the form, it is coming up as
The code for the guarantee list is :
=ConcatRelated("LE_shortname","MT_guarantee_list","REF= " & "[ref]")
The list does not even match the ref, it appears for all records. Any help would be gratefully received.
Many thanks
This is the table
The code for the guarantee list is :
=ConcatRelated("LE_shortname","MT_guarantee_list","REF= " & "[ref]")
The list does not even match the ref, it appears for all records. Any help would be gratefully received.
Many thanks