LinkedIn
Twitter
@Aleksi
Having below tables with links.
- Inspection Header (Master Table)
- Inspection Checklist (Child Table for Inspection Header)
- Observation (Child Table for Inspection Checklist)
- Media (Child Table for Observation)
I have set two different options for sending reports.
- Report from Inspection Header (Action button to send a report) - picture 1 and 2
- Common option (custom report) to send a report by selecting inspection id.
The 1st option for sending report is successful as advised.
The problem for 2nd option to send a report from common option - picture 3 and 4
The media table is not working says โrelated observationsโ not found. - picture 5
How to construct the <> expression. please.
Attached screen shots for two options for reference.
Solved
1 ACCEPTED SOLUTION
Your template should contain a Start expression like:
<<Start: SELECT(Inspection Header[Inspection Code], [Inspection Code] = [_THISROW].[Inspection Code])>>
Between the Start and End expressions, you should format the Inspection Header record.
Based on your โReport from Inspection Headerโ that might look something like:
