AnsweredAssumed Answered

Help producing a report with images

Question asked by JamesBarnes on Apr 23, 2011
Latest reply on Apr 24, 2011 by LaRetta_1

Title

Help producing a report with images

Post

I'm fairly new at this & am struggling to figure out how to produce a customer report with multiple products each with product name, description & image 

I have these tables – Customers, Workout Program, Exercises

The exercises table has: ID, Name, Description & Photo

I’m currently using my ‘Workout Program’ layout with 15 drop down list fields that allow me to select their values from the ‘Exercises’ table. The idea is that each customer has a workout program with 6 or 8 or 11 etc different exercises (up to 15).

This is what it looks like

Exercise List

I need to produce a report for each customer that shows all of the exercises selected in the above layout, plus the Exercise name, description and most importantly Exercise Photo from the exercises table

In summary:
Each customer can have up to 15 Exercises
I need a report for each customer that shows all of the exercises selected + the exercise description & exercise photo

The report to look something like this

Exercise 1 Ecercise 2 Exercise 3

Exercixe Name

Description

Photo 

Exercixe Name

Description

Photo 

Exercixe Name

Description

Photo 

Exercise 4 Ecercise 5 Exercise 6

Exercixe Name

Description

Photo 

Exercixe Name

Description

Photo 

Exercixe Name

Description

Photo 

Outcomes