Jan 20, 2020 07:03 AM
Hi there! Thanks for your help in advance!
I’m creating a form for my customers, so they can request my service on a specific date–up to 6 products to be processed on that date. Each product has the same questions they need to answer.
So, I have 2 related tables - the Customer and the Customer Request .
Since the questions are the same for all the products (for the date of that request) am I correct that my Customer Request table wouldn’t need to ask those same questions 6 times?
In other words, it doesn’t make sense to me to add the same fields on the Customer Request table (asking the same question 6 times for up to 6 products)?
Is there some way on the form (e.g., a “Add another Product” button) to take them through the (same) questions again?
TY!
Jan 20, 2020 07:57 AM
Unfortunately, I’m not aware of a ‘add another product’ button. It would make a good product suggestion.
Jan 31, 2020 09:53 AM
Update: realized there’s a solution involving linked records