Creating a Purchase Order from my Supplier Database

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]



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

Can it be done in Air Table?