My problem with joins

Saumier

Member
Joomla 2.5.4 Fabrik 3.0.5.2 github 168

I have 3 tables:
users key = id parent table (Joomla users table)
profile key = pid child 1 to 1 with users (Fabrik table)
payments key = rid child 1 to many with users (Fabrik table)

I have a form to add a user, using juser, form contains 3 groups: users, profile and payments. Form works good inputting all the data.
When Save, record is written correctly to users and profile, record is written to payments but rid (the key) is always NULL. (Primary key in profile and payments tables is Fabrik "id")
I have tried joining payments to users or profile, but result is the same.
Attached are my settings:
I just can't figure out how to set up the joins to accomplish this.
 

Attachments

  • r01.jpg
    r01.jpg
    123 KB · Views: 129
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top