One to many search difficulties about pyairtable

[mesozoic]

You should be able to search the record link field using the value that you'd see in the primary field of the linked table. In your case, if Série is a record link field to a table called Series, you'd want the serie variable to contain whatever value appears in the primary field of the Series table.

Hope that helps! I'm closing this issue as it doesn't appear to be a problem with the library. If you think you've encountered a bug in pyAirtable, please post more details and an example of how to reproduce the bug.

[Garito]

It is not a bug in pyAirtable
I've tried to look for a record in the many part and the primary key is stored as [value]
Does it mean that my client has configured the field as a many-to-many relationship?
If so, can this configuration be changed without loosing data? or
How can I search it as a list of keys?
I've tried match({"Série": [serie]}) but it raises an error

Thanks

[mesozoic]

That's true: Airtable will always return record link fields as a list of IDs, regardless of whether the UI is configured to allow multiple records.

I don't think it is possible to construct a formula that searches on the list of record IDs in a linked record field. You might have more luck finding workarounds on the Airtable Community forums.

[Garito]

So airtable is not a good solution then (nor a real relational database)
Thanks, I will stop recommending it to my customers