I have a databasejoin, rendered as checkbox, 'my_table___join' joining to another table 'my_other_table'. I set the value as 'my_other_table___id' and label as 'my_other_table___name' and then in the where clause I make sure to select only appropriate rows using 'WHERE {thistable}.link_id = '{my_table___id}', {thistable} here referring to my_other_table
Works great for displaying the right rows in the dbjoin, but when saving I get the error 1054 unknown column 'my_table_repeat_join___link_id'. Somehow when saving {thistable} is no longer my_other_table, but the created join table 'my_table_repeat_join'.
Is this intended behavior, and if so how do I make it work? Or is it a bug?
Works great for displaying the right rows in the dbjoin, but when saving I get the error 1054 unknown column 'my_table_repeat_join___link_id'. Somehow when saving {thistable} is no longer my_other_table, but the created join table 'my_table_repeat_join'.
Is this intended behavior, and if so how do I make it work? Or is it a bug?