Combining datasets for a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 03:43 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2024 06:20 AM
Sounds like you need a database view to join the two tables together and use the view table for your report or widget.