I have a gallery that displays data form SQL Azure Database. on the gallery cards, I have used a lookup function to display some values from another table as well. My issue is that the value returned by the lookup function is sometimes just .... wrong. The lookup criteria is something to the effect of foreign_key = thisitem.id, and it is just really really inconsistent. sometimes every card in the gallery will be correct. other times, the cards will all show the same (incorrect) value, and other times they will just be showing random incorrect values from the related table.
What might be causing this? Why are lookup functions inconsistent like this? When relating foreign keys to primary keys of other tables the result should be consistent, and the expected value is tied to the primary key. Has anyone else experienced this erratic behavior using Lookup functions in galleries? I'd appreciate input here!