I have some knowledge of SQL databases and I know how I would do this using that. I would like to know what is the most efficient and easiest way to do this on bubble.
- Table 1: I have a table with country, population and tax rate.
- Table 2: I have a table with country, property-name and rent.
User selects country in form number 1 (Table 1) and on the next page I want to show all the properties and the corresponding rent for the property (Table 2) based on the country that the user has selected on the previous page.
One way I could do it is to send the country data from the first page to the second one. And then on the 2nd page make a repeating group with dynamic data where it shows property-name and rent if the value of country in table 1 = value of country in table 2.