Trying to get my arms around how we might use InfoPath forms (published to SharePoint). What are the various methods for producing reports based on data entered and forms saved? Using the requisition form as a model, how can we report on who ordered what supplies using the form?
I see the promoted fields option. Is this the key to reporting?
Also, is there a way to guarantee a table (list) relationship? Meaning if a supply item is associated with a vendor and someone tries to delete the vendor from the vendor list, an error message will display and not allow this deletion until the supply items associated with this vendor are deleted? Otherwise we have orphan supply items not associated with a vendor.
