I have run into a new form problem regarding long tables of products that are the first, but not only options needed in a form.
The User logs in and must complete a form that must allow them to first choose from over 100 products --- as MANY PRODUCTS as apply to their reporting situation.
They may have sold say, 7 different categories of products, or 8 or 35, etc. etc. of these separate products and must now report for each product 3 different field values -- Total units sold, How many to Existing Customers, How many to New Customers.
When the User finally hits the Submit button it must produce multiple Rows that match the number of Products reported on ..
"Insert into table 'productreport' VALUES 'null','etc, etc and then a ; semi-colon
followed by another INSERT into table 'productreport' VALUES 'NULL', etc.etc. until the Form submission has produced 7 auto-numbered rows for 7 Products with different values in the quantity fields. Or, for instance, 3 Selected Products to Report On, produce 3 separate rows in the master productreport table.
What I cannot figure out is HOW TO CREATE the Form DYNAMICALLY.
I can not reasonably create a super long form with well over a hundred rows of product fields that must contain a row for every single Product Item with 3 more accompanying fields for quantity reports.
The view below represents the data the Form itself would contain if just the First 8 of (over a HUNDRED products) were Selected to Report On,
The "Bought, Existing Customers, New Customers" columns would be filled with Numbers. The Price column value is read-only.[/b]
[size="4"]
With PHPRunner I know I can create a product reference table with just the fields: (product id, product key description field, unit price field) and choose that in the Lookup Wizard setup but this only produces one field's information.[/size]
[size="4"]Can this Form be programmed to be Dynamically assembled by the User Choices from the Product Reference Table?[/size]
[size="4"]In other words, is there a way to have the User select from 3 products or 6 or 99 products and then have JUST those products appear on separate form rows with matching input fields for Units sold, Number to Existing Customers, Number to New Customers?
So that the form is never longer than the number of Products the User selects to make a Report about?[/size]