Hi everyone,

I have a JobSite table with a Card View , and it has a one-to-many relationship with the Assets table. Each record in the JobSite table can be linked to multiple records in the Assets table.

What I want to achieve is:

When I click a button in the JobSite table, it should open a new view displaying only the records from the Assets table that are linked to the selected JobSite.

Key Points:

• JobSite Table: Contains details of job sites.
• Assets Table: Contains details of assets linked to specific job sites.
• The two tables are already linked with a one-to-many relationship.
• I want the button in the JobSite table to:
  1. Open a view (preferably in a table layout) from the Assets table.
  2. Show only the assets related to the currently selected job site.

How can I achieve this in Ninox? Do I need to write a script for the button, or is there an easier way to set up this behavior?

Any advice or examples would be greatly appreciated!

Thanks in advance!