Show Repeating Data
-
Hi, I have a webform that shows summary information at the top of the page. If there is only one "row" in the database for the associated project, the summary looks like this: Tool_ID= "returned value" Tool ="returned value" Tool_Quantity= "returned value" However if there are multiple tool_ids associated with the project in session (ex, 2 tools), the summary will display each tool in its own column: Tool_ID= "returned value" Tool_ID= "returned value" Tool ="returned value" Tool ="returned value" Tool_Quantity= "returned value" Tool_Quantity= "returned value" The maximum number of Tool_ids that can be associated with any project is 3. I have a query that will search the project and get the tool_ids, tool and tool_quantity, but I dont know how to code in to display the output as I have listed above. I also need this to be able to get updated as the user can add more tools to the project before submission. Please help! Thank you