AnsweredAssumed Answered

script to Automatically update child table related to parent table

Question asked by atika on Jul 23, 2018
Latest reply on Jul 23, 2018 by wimdecorte

Hii guys,

I hope you would be fine. Actually i have question and i try in different ways but can resolve that query. I have two table deviceMeasurement table (device_id, user, and place) called parent table and device history table (devicehistory_id, device_id, device, user, place) called child table. Now i want if i create new record or change anything in the existing field in parent table i.e. deviceMeasurement then these changes automatically done in child table.

The scenario is like that if create a new device and set that the deviceA have userA and placeA

or change anything in the existing device then it automatically happened in child table. The basic idea is DeviceHistory table (child table) keep history of each device i.e device A have userA,B,C and places A, B, C.

I would be very thankful to you if someone reply...

 

Outcomes