There are multiple builds per character, so that comes from a builds collection and its presented through a repeater. Then for each build there are recommended weapons which comes from a data collection linking builds to weapons with an order field (num) so I can showcase the weapons in order of preference. As you can see from the live page it is not working as the ‘build’ repeater is not accepting the ‘weapons’ repeater. I could work around this by hard coding weapon 1, weapon 2, etc but that seems a bit of a waste and not a proper database solution. Is there a code solution here?
Ok, I have voted. It honestly seems like an absolute must have regardless of this having only 49 votes
There must be many scenarios where you need to run a nested query. For now I will just hard coded weapon slots I guess but this kind of defeats the purpose of having this all in data collections.