I note that you Estimates table does not have a product ID field; only a Brand.
Therefore, when creating estimates, right now, for instance, you can order the complete set of all Apple products.
But you can't PICK a product and order that one.
Brilliant!!! That was soon easy. Can't believe I missed to.
Thanks a lot.
I'm not 100% sure what you mean.
I notice when I create a new estimate, the estimate data table remains filled with the products from the previous estimate. Is this what you mean?
What do you suggest I do? I suppose just create a "Product_ID" field?
Will this solve the problem of "not creating a blank portal when I create a new estimate problem"?
1. Of course you should add a Product_ID field. Which particular products are in THIS estimate?
2. "I notice when I create a new estimate, the estimate data table remains filled with the products from the previous estimate."
This should be impossible. Doesn't the new estimate have a new, unique EstimateID?
I got it to work.
Thanks for your help.