@code-queen Thank you once again for your help. I have made some progress this morning and feel I’m getting closer and closer ![]()
In the ‘Program Plans’ data collection, I added another column called ProgramID (made it primary) and manually added the unique ID’s for all the pricing plans from the read-only Plans data collection. (is there a better, more efficient, less prone to error way to accomplish this?)
Next as per your feedback, I have made the plan ID a reference field in the ‘Purchases’ data collection …referencing the ‘Program Plans’ data collection.
I connected my repeater to the ‘Purchases’ data collection and was able to connect all the repeater elements to the ‘Program Plans’ data collection via referencing.
Now I’m a bit confused with the logic. As I mentioned earlier, the ‘Purchases’ data collection has two fields (MemberID and PlanID) that get populated automatically using the events.js code. So by making the PlanID field as a reference field (connected to the Program Plans data collection), it seems I am breaking that logic. See screenshot below.
