Hi there,
Been trying to sort this out for a while with no luck...
Will explain what I have:
List 1 called parent with info about parent that is imported. it's has a member_id which more that one parent can have.
List 2 called childrens in the same situation as parents list, with a member_id which more than a child can have.
List 3 called user which is populated by parents and used juser to create a joomla user and have a member_id. once a parent registered the member_id is checked.
List 1 and 2 has a join to list 3 using the member_id in order to get the user_id so list 1 and 2 are prefiltered with the user_id using {$my->id} so parents can only see their related info.
Up to know everything works perfect.
A new list 4 called activities is created also imported by csv with info related to the activities childs can do.
Another list 5 is needed where parents can sign their childs in the activities.
In this form 5 a database join element was created so the parent can only choose the children that member_id is the same as the logged user. This is where the problem is as all parents can choose all childrens.
Any ideas?
Thanks
Been trying to sort this out for a while with no luck...
Will explain what I have:
List 1 called parent with info about parent that is imported. it's has a member_id which more that one parent can have.
List 2 called childrens in the same situation as parents list, with a member_id which more than a child can have.
List 3 called user which is populated by parents and used juser to create a joomla user and have a member_id. once a parent registered the member_id is checked.
List 1 and 2 has a join to list 3 using the member_id in order to get the user_id so list 1 and 2 are prefiltered with the user_id using {$my->id} so parents can only see their related info.
Up to know everything works perfect.
A new list 4 called activities is created also imported by csv with info related to the activities childs can do.
Another list 5 is needed where parents can sign their childs in the activities.
In this form 5 a database join element was created so the parent can only choose the children that member_id is the same as the logged user. This is where the problem is as all parents can choose all childrens.
Any ideas?
Thanks