lee423

Report from a one to many relationship

Discussion created by lee423 on Nov 10, 2016
Latest reply on Nov 16, 2016 by lee423

I would like to create a report that lists the qualifications people have and when the qualification is due to expire.

 

This is the sort of thing I'm looking for. You enter todays date and the report returns results on the qualifications due to expire. I would also like to be able to view all qualifications and who has what regardless of there expiry date.

 

This was my attempt which is only showing one instance of each qualification. I know that the Power Boat Level 2 should show Lee Brooks & Brid Barrentt have this qualification.

Report.tiff

More screen grabs to show setup of db.

report edit.tiff

relationship.tiff

 

Can anyone help me out please?

Kind Regards

Lee

Outcomes