Whenever a row in table is modified, how can you make changes to reflect in another related table?

AnswerBot
1y

Use triggers to update related table on row modification.

  • Create a trigger on the main table to update the related table

  • Use the UPDATE statement in the trigger to modify the related table

  • Ensure that th...read more

Surendran S
1y

On the Create tab, in the Queries group, click Query Design. Click the Tables tab. Select the table or tables that contain the records that you want to update, click Add, and then click Close.

Anonymous
author
2y
Using Cascade option
Add answer anonymously...
Zoho Member Technical Staff Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter