Wondering if I could get some help/advise
I have a few fields in a collection, one of them is a relationship to another collection. If I try and update a row in that field it all works apart from the field that is the relationship. I am getting the value for this filed from the logged in user and it matches a value in the collection.
Is it possible to update a field in this way? If I do it manually (In the database) then I am forced to choose the value from a drop-down.
Any help appreciated