Added line items in enquiry form to be visible as line items in order form(diff form)

[avlasercrafts]

i use to create enquiry for products, so i add products as line items in enquiry form (Enquiry Form) and submit. So the added line items are stored in another google sheet (Line Items). Now while placing order for that enquiry with different form (Order Entry Form), the line items associated with that enquiry should be automatically listed into the order form as line items (Child record is common for both forms).

ENQUIRY FORM -----> ADD LINE ITEMS -----> SUMBIT

                                                       |

ORDER FORM ------> LIST OF LINE ITEMS (added in enquiry form)-----> SUBMIT

[Marc_Dillon]

Assuming the order record has a ref column to the enquiry record, create a virtual column of [enquiry].[related line items]