Hi @jason,

Thanks for responding. I was not aware that this is how the related field relationship worked in the database. If I understand correctly, with this relationship, you are saying that the store (owned object) would point to its owner using the __post_relate key. Upon doing the query in the wp_postmeta table for the store, I see many __relate_post keys representing the various products. However, when I a sample individual product, I still have the store_location field, which is where the stale data is. This essentially would be a pointer in the opposite direction, where a product points to the store that its at by storing the store ID. When I update this value the issue is resolved. That value in the defined store_location field gets initialized correctly but then never updates.

Am I misusing the related field in Piklist? The only relationship I really need to store is the product pointing to the store location by storing the store location post id in the “store_location” field of the product in the wp_postmeta table. Should the related field update the pointers from both directions?

Thanks.