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...