Hi:
I have a table and form "Estimates" for quoting installation prices. Currently I have quantity, manufacturer, part #, part description, and price 1-8, for entering up to 8 parts on one estimate. However, using this method I can only enter 8 parts per estimate, and if I have fewer than 8 parts, I have a bunch of empty fields in my record. Is there a way to use only the number of parts I need on the form and when the user enters the last piece of information, there is a way to add another part to the same estimate? Is this a design flaw in my database or something that can't be helped? Any thoughts are appreciated, and I apologize for my ignorance but I'm pretty new at this.
Thanks!
Miranda
I have a table and form "Estimates" for quoting installation prices. Currently I have quantity, manufacturer, part #, part description, and price 1-8, for entering up to 8 parts on one estimate. However, using this method I can only enter 8 parts per estimate, and if I have fewer than 8 parts, I have a bunch of empty fields in my record. Is there a way to use only the number of parts I need on the form and when the user enters the last piece of information, there is a way to add another part to the same estimate? Is this a design flaw in my database or something that can't be helped? Any thoughts are appreciated, and I apologize for my ignorance but I'm pretty new at this.
Thanks!
Miranda