Problem in getting info as for a lookup but with advanced mode

Hello there, I would like to display in a collection a data that is in another table (i’ve established fk between the two in my backend Supabase, from “CA” to “Concession”) and when I try to, it’s apparently working but I can’t have my embed data.
Some context : a “concession” has several “CA”, but a “CA” has only one “Concession”
Do you know why ?
I hope this is cleat enough, see the picture below for better understanding

Could you also post your database schema regarding this table? Also, I heavily discourage using apostrophes, uppercases and other special characters (except for dashes) in the table names, that might cause a bunch of problems of it’s own.

That is really unexpected but changing the db name from CA’s to CAs solved the problem … is it really that important haha ?

1 Like

Yes, because of how it works underneath :slight_smile: I thought this might be causing this. I suggest using lowercase without fancy chars for table names - you can use underscores.

1 Like