Forum Discussion
Solved
Repeat report section
Hello All, I need some help in creating a report in certain way. Below is the relationship of the three tables (ignore the other lines). There is one risk and this risk is having 2 actions and 3 ...
Hi,
How about subreports (linked to the main report via the Risk_Id field) where you display the Response and Assessment records. This would allow you to control the placement and order in the report as desired.
Probably 1 subreport is enough, but you could also use subreports for both detail tables.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
Not your current problem, but you should also ENFORCE the relations on the diagram.
Double-click a line, and in the dialog that comes up, check "Enforce Referential Integrity".
Only after that can you call your database a relational database, instead of a bag of data 🙂
Double-click a line, and in the dialog that comes up, check "Enforce Referential Integrity".
Only after that can you call your database a relational database, instead of a bag of data 🙂