I need some ideas on how to accomplish this task. Basically my app is a rating app where a user takes a photo or uploads one from existing, and reviews the photo (Custom Built furniture.).
So far here is what I have:
Photo Upload Service: I take photo or select one from existing and post them to Files collection. I upload the images to Files collection and also save the image Original File Name to 4 LSV.
Review Upload Service: I get all fields and the file names and upload that to Review collection.
So basically I am using 2 service to put post 1 review and everything works well so far.
To read reviews here is where I am stuck.
Ideally I want to be able to query the Reviews collection and grab the reviews+ Pictures all in one service.
Challenges: I know this situation would be perfect for pointer but.....In Files collection I cannot create a Pointer to Reviews collection. In Reviews collection I cannot create a Pointer to Files collection all other collections I have it is possible (not sure why) which means I will have to use two services. Service 1, to get the reviews and Service 2, Use the File Name I stored in Reviews collection to get the image from the Files collection.
Is there a different solution to this limitation? Am I missing something?
I appreciate any ideas I have wrestled with this and cannot find a solution