Field - Related Access

This field allows to restrict access to articles based on Emerald Subscription selected in parent article.

For example you have type Course and type Lesson. You create Course and then attach Lessons to it. And you want indicate in the Course, the subscription to restrict access to Lessons.

Create selectable field (select, checkbox, radio, multiselect, listautocomplete) with SQL source in the Course(patent). Insert following query.

SELECT id, name as text FROM #__emerald_plans WHERE published = 1

now in Lesson type(child) create related_access field. You have to select selectable field you created where you select Emerald plan, so this field knows where to look for plans.