Creating a Purchase Order from my Supplier Database

[Wilma_Hartmann]

I have a Supplier CRM in a base with tables for Company and Products (linked to the Company table). Can I create an Order Form and fill the fields in the form by selecting the Company Name and the Products I want to order from my Records in each Table?

Ideally, I’d like to create all my Purchase Orders, numbered and dated, and store the Purchase Orders.
A form like:

COMPANY: Joe’s Soap

DATE: [Today’s Date]

ORDER:

QUANTITY | PRODUCT

---

7 x Pink Soap
2 x Green Soap
4 x Yellow Soap

Can it be done in Air Table?

[Matteo_Montecch]

It would be helpful also for me!

[Noamsay]

Hi @Wilma_Hartmann
What about a form like this : https://airtable.com/shraPfiQYJLEf2qJq?prefill_Company=Joe's%20Soap&prefill_Date=2020-02-23T00:00:00...

[Alexander_Dimce]

Hey! @Noamsay Your solution doesn’t do the job. What if there are 10,000 products?