Combining datasets for a report

gunishi
Tera Guru

Hi there, 

 

This is quite general and just just trying to feel out how I might do this. 

 

I have a requirement where I have a list of fruit, where each fruit record contains info I want to display. I also have a list of cutting techniques, where on the cutting technique form, there is a field called 'fruit'.

 

I want to have a widget on a report where the user can see a list of fruits and associated cutting technique records. 

 

Is there a way to do this?

 

Kind regards, 

G

1 REPLY 1

The Machine
Kilo Sage

Sounds like you need a database view to join the two tables together and use the view table for your report or widget.