Databasejoin element return error on list & detail view

[Aurore]

Hello !
I need help, i might miss something !
I try to create a databasejoin element connecting to another database (which is entered in Connection tab)
My form is on DB A, my databasejoin connect to DB B and choose my regions table.

Everything working great on form : The databasejoin's dropdown showing me every regions.

But on list & details view, i got a 500 and a 1146 error, even if there is no raw on the table.

I just want to be sure : Can i create a databasejoin element to another database ?
If not, do you have an idea of how can i get those values ?

I tried in case to create List's Join and related data but i didn't made it work.
Thanks in advance !

 

[cheesegrits]

We don't support cross database joins. So your joined table has to be on the same database as your form.

The only workaround for this would be to create a MySQL view on your form's database, which does something like ...

DEFINE VIEW regions AS SELECT * FROM dbB.regions

... so you essentially have a copy of the regions table on dbA. It would be "read only", so you couldn't add rows to it, but would work as a simple lookup table.

-- hugh