Hi there,
In case it helps:
-
on a dedicated plan you can use SQL to access your Anvil data tables.
-
you may be interested in the Anvil query operator which allows for very powerful query statements
I’ve tried to understand the example you wrote above, but there is not enough detail (for me anyway) to determine if there is a way to accomplish what you are attempting using Anvil data table links. If you have an example app to share and a more detailed description, it may be possible for us to help you figure out any immediate roadblocks.