Forms - Lookup search on multiple fields
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.
An Order Form for Multiple Products
Invoices & Line Items (Example Base) - Airtable 549 https://airtable.com/shrARpjHsxF9gAZf4/tblD9dhzRj1azFYiu/viwYyRZbubYD30Lh9?blocks=bipM8uJi4OjyCogN5