I want to do the following:
- Open a prefilled form in Table1
- Force a sync
- Go to a form in Table2 to edit a specific row
In Table1 I set the Key value for the specific row in Table2.
This is working fine. But I would like to add a security filter in Table2 like:
[Key] = ANY(Table1[Key])
When I do this, it would need 2 syncs:
- Save Table1
- Fetch Table2 with the specific row
Here are the 4 sync steps. And I would expect that one sync would be enough: Saving Table1 and fetching Table2.