I'm new to InfoPath and SharePoint, so bear with me. I have two lists, a parent list that contains orders and a child list that contains items. The items list has a foreign key that corresponds to the order ID. I can join these two lists into a read-only view just fine, but is there a way to create a new order form that would submit to both these lists?
For example, fields on the order form would include Originator, Delivery Address, etc. and then there would be a repeating data table with fields such as Item Name and Quantity. So the order form would submit to the Orders list, and also to the Items list for each item the user has filled out.
I know I'd probably be better off using a Form Library, but I've been instructed to only use lists. I've done quite a bit of searching and I can find plenty of information on joining two lists in a read-only view but not much on submitting new data to two different lists. Is this even possible, and if so, what's the best way to do it?