About saving joining tables

[michel_snyers]

Hello,

I have 2 tables T1 (master) and T2 (child) which have a one to many relationship (T2 with repeating group).
The T1 table can not be changed only table T2 can be.
How to avoid an update of master table when I save the 'edit form' (only the data of T2 can be updated or added)?

Thanks

 

[cheesegrits]

Have you tried setting the main group to "read only" in the group options?

-- hugh

 

[michel_snyers]

Thanks for your suggestion but I looked for this option and I didn't find it.
I have already set all element of the main table to "read only', 'd?sactiver ?l?ment? : nothing works.
In fact, the main table point to a view un-updatable.

 

[dimoss]

Better make a new access level like 'Nobody' and don't assign any group on it.
Then in the Fabrik Group options set this access level to access options.
This is how I did it and worked.

This trick help you in multiple ways.

 

[michel_snyers]

Better make a new access level like 'Nobody' and don't assign any group on it.
Then in the Fabrik Group options set this access level to access options.
This is how I did it and worked.

This trick help you in multiple ways.

Hi dimoss,

Thanks for your advice but nothing to do. I have tried your suggestion without succes.
Only the error message has changed :

1393 Can not modify more than one base table through a join view 'gazette.gazette_identite_users' SQL=UPDATE `gazette_identite_users` SET `name`='XXXXXXX',`prenom`='YYYYYYYY' WHERE id=''

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE' at line 1 SQL=UPDATE `gazette_identite_users` SET WHERE

It seems ,when we have 2 related tables, that all data on the form are saved (master data & child data).