Updating multiple fields in the link table in One-to-Many joins

Updating multiple fields in the link table in One-to-Many joins

salpautisalpauti Posts: 7Questions: 5Answers: 0

https://editor.datatables.net/manual/php/mjoin provides examples of a one-to-many join using a link tables which has a live example at https://editor.datatables.net/examples/advanced/joinArray.html.

My link table has an additional field which I'd like to populate with a preset value when inserting new records. I don't want to show this field in Datatables/Editor and want it set to a fixed value during inserts.

Is this possible?

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,665Questions: 1Answers: 10,096 Site admin
    Answer ✓

    I'm sorry no, not directly. The only option would be to use a server-side event such as postEdit to update the link table after each create / edit.

    Allan

This discussion has been closed.