Pour des alternatives voir lowcode databases
https://airtable.com/marketplace/blknmXKkZjB7scdSq/search
https://support.airtable.com/hc/en-us/articles/115013249467-Search-app#h_01FZ8VVHP94STBD4MY6JY33NX9
Unfortunately, Airtable form fields can’t be used to search across multiple table fields. Each field in a form ties to a specific field in the table where it lives. To do what you want, you’ll need to enlist the help of a more robust form system, or code a custom form that searches behind the scenes using the Airtable API. I don’t have direct experience with the latter, and only marginal experience with other form systems, but nothing tied to your use case. Here’s hoping some others will chime in with info that could help you.
Invoices & Line Items (Example Base) - Airtable 549 https://airtable.com/shrARpjHsxF9gAZf4/tblD9dhzRj1azFYiu/viwYyRZbubYD30Lh9?blocks=bipM8uJi4OjyCogN5