Need form that contains fields from multiple tables


#1

I have products, customers, orders and orderdetails. Orders links to customers, and orderdetails links to orders and products. I’d like a form that I can enter a productID and then have the form filled in with all the customers who ordered that product. Is this possible? If not, can I create a view that just list all the products and all the customers who ordered each one? Thanks


#2

You may want to look into the “prefilling a form” feature

But you would still need to automatically get all the customers who have purchased that product to to pass to the prefill_ parameter to populate your Airtable form with.
You would need to use the Airtable API or some third party service such as Zapier to achieve this functionality.

Another and more simpler method as you have rightly suggested would be to create a view to list all customers who have ordered a particular product.
You will probably need to add some “lookup” fields to your table to achieve this.