Say, I have a customer request form where customers will go and submit a repair order. Is it possible to add 6 rows of order to customer's form automatically.
CustomerRequestForm is a list
AutoOrders is a list with 6 orders (6 records of data or 6 rows of data)
Would it be possible to add 6 orders automatically when customer opens the CustomerRequestForm and save the data in a separate table (like customer and orders, 1 to many relationship).
What are my options? How do I implement this properly? Basically, I dont want to have 40 extra columns in the CustomerRequestForm from the second table since each order has 7 columns of info in the autoOrders table.