Hi,

This will depend on what you want to show and your logic but I'll give an example. Assuming you want to show Expense Reporting records (with a reference field for Incidents) with a Major Incident state of 'accepted', and that you have logic to set the u_major_incident_state field on ER:

Expense Reporting is View Table with order 100 and no Where clause.

Incident is View Table with order 200 and following Where clause:

incident_sys_id = er_u_incident && (er_u_major_incident_state = 'accepted')

The above is an example only. It is hard to give you more guidance without a better understanding of what your logic and requirement is - however, I'll outline the basic framework.

• Your lowest order view table will not have a where clause
• Your next table(s) use where clauses to define what you want to see
• Your where clause generally references the current view table and what it matches on the preceding table - such as where your incident is in a reference field and a certain value should be checked.

Please let me know if this was helpful or if you need any further guidance. This sort of thing is best learnt through practice.

Kind Regards,

Astrid