Editor with Joins
Editor with Joins
arnorbld
Posts: 110Questions: 20Answers: 1
Hi guys,
I'm working with a user table. I'm creating a related table, userConfig where I need to add ONE row for each user as they need to. The userConfig table does NOT have a record for each user to start with. I.e. when I start with this, the user table might have 100 rows, the userConfig will have 0. This is a 1:1 relationship, one userConfig row per user.
So I need the HTML table browse the user table and then I need to be able to call a form to insert/update data in the userConfig table.
I know the editor supports joins, but since I'm not editing anything in the user (parent) table, only in the userConfig (1:1 child) table, I'm not sure exactly if that can be done and how. It would need to know to insert a new record into userConfig if it doesn't exist.
Any suggestions would be most welcome 
Arnor
Replies
So your DataTable is based on the
usertable? But you want all editing in this case to happen on theuserConfigtable?If they both have the same primary key column name and value (i.e. use that for the join, so
userConfigdoesn't have an auto increment) then I think what you are looking for could be done with thereadTablemethod in our server-side libraries.You can see that in action here where it is being used to read values from a VIEW, but write to a table. In your case you would read from
userand write touserConfig. To be honest, I haven't tried that, but that's what I would try in the first instance. The benefit of this method is you can use all the Editor validators and stuff.However, it wasn't really designed with that in mind, so while I think it might work, I might have forgotten something... If that is the case, then I think you would need to use server-side events - so on
preEdityou could do an upsert using ourpushmethod...Sorry I don't have a straightforward answer for you - but please let me know how you get on with this one.
Regards,
Allan