Is it possible to reset the counter when adding a new record in MS SQL?

Question

SQL Server

There are two tables. In one autoincrement file id , in the other autoincrement page id. The tables are linked by a key by the file id. DB schema
As a result, I want to make sure that when the file id changes, the page id is reset to zero. For simplicity and clarity, I will attach an example

Answer 1

Write a trigger for change in it, analyze the changes and take the necessary actions.