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?
