How to search though multiple tables and show results in repeating group?
I’m working on creating a beer app. With this app you save the name of the beer, the brewer, your comment on the beer and your rating.
For this I create 3 tables in the database:
- Beer. , here I save the name of the beer.
- Brewery. here I save the name of the brewery
- Opinion. here I save the comment and the rating of the beer.
Within the opinion database I have the ID’s of the Beer name and the Brewery name.
What I’m trying to accomplish is the following.
The user added multiple beers and wants to search though them. He doesn’t remember the name so want’s to search for a word in het comment he added. And for another beer he does the remember the name and would like to search on the name of the beer or the name of the brewery.
It would be nice if the user could search/filter by using text and that the results will be visible in a repeating group.
I already tried to solve this problem by using the Search&Autocorrect plugin but that only allows me to search though one table…
Does anyone know how I can accomplish this?
Thanks in advance!