I have been tasked to create a form to submit product forecasts to SharePoint. I am not sure if this is going to be doable and when testing I am unable to make it work so I could use some help. I have a basic form and a cascading drop down menu where a sales rep can select a product manufacture and then a product type, and then product. They enter in the qty they think they will sell next year and move on to the next product on the same form. I am trying to get each line of product to save that info with qty into a separate list that will aggregate the totals for all our sales reps. Is this at all possible? Using the Connected to Field doesn't work as each product they enter will need to be a single entry on a separate list.
Thanks for any help one this!