Can you please attach some screenshots to show the edit screens for all post types and taxonomies involved?
It is important to see where the relationship field is and how all the data is related.
I can see that the issue revolves around categories, but these arn’t mentioned until the end and I don’t understand how they are used. Perhaps you can describe this a bit more? Screenshots will be great to show how all the data is related
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users