Filter between two relationship component issue

[beastmen84]

Dear all,
I'm new to Budibase, so probably I'm doing something wrong :)
I'm using a local docker installation with the embedded DB.
I created two tables, one Countries with a name column and a Regions again with a name column and a country relationship field connecting to the Countries table with a many to one relationship.
Then I created a Missions table where i created, in between other fields, also the country and region fields each as a relationship to the related table as many to one.
Now in the app I created a form connected to the table missions, then added two relationship picker, one for country and one for region and it works. BUT I wanted region to be filtered based on country selection and I can't get it to work.
In Region filtering i can only select Country or Country.name; for country i can only select empty or not empty, for country.name i can say equals to {{ [New Mission Request Form].Fields.country }} but this: {{ [New Mission Request Form].Fields.country }} refers to the id not the value so they do not match. I do not have Country._id in the selection.
What am I doing wrong?
Thanks so much for your support :)

[mikesealey]

Hey @beastmen84 - this sounds like an interesting use for Budibase!

Have you looked at this guide?

You might need to also add an auto-column of "Auto-ID" to your tables and filter on that. The Workspace export is available at the bottom of the page if you'd like to take a closer look.

[beastmen84]

Thanks, creating a Data Provider works, the issue is that if I add the country selection as an Option Picker, selecting optional source with the data provider as stated in the guide, I cannot select the table Countries in the Field selection and when saving the form the country does not get added in the table because I'm matching the country and region through an AUTO-ID field, not the actual _id. And in the save button I cannot match the country column of the table with the relevant _id of the selected country.