Sorry, I did not read this carefully enough. You have the right idea to make a child table for Category, Description, Price. The Category field in the child table would be a drop down list.
In the Parent Estimate table's form, embed the child Category record. You do this by embedding the report link of Estimate, then, in the properties for the Parent Estimate form, go to this report link. Configure on the right hand side to "display related Category directly on the form".
Estimates Parent >>> Child Category, Description, Price table.
Does this make sense?
Actually, you're off to a good start and you have exactly what I envisioned and explained. The user would create the Category child records in the Grid Edit report you have there. The Estimate parent record would be created at the same time as those child records.
If you ever wanted to make edits, just pull up the parent Estimate record, or, you can open each individual Category child record and edit those individually in their own form.
But, what you have here is excellent, and you're demonstrating an equally excellent understanding of QuickBase and how it works.
Hi, I have the same question as well.
Basically, I have a drop down (lookup) field - company name, which is linked to the "Company" table. Would like to have multiple of it on the "Sales Enquiry" form, in case we get the same job enquiry from different companies.
Tried duplicating the field and included that in the form, but it won't show 2 different company name records