I am developing an estimating application and at the "quantity takeoff" level, all products/equipment/sub contracting/etc.... end up on the same table because of the common elements:
Item | Quantity | Unit Price | SubTotal | Total
Now, since the unit price of a product is not determined from the same tables as the unit price of equipment rentals or sub contract work, etc...
how do I direct the attention to the appropriate table when trying to obtain the unit price or edit the unit price etc...
If my question is not clear, let me know, I will try to clarify.
Originally posted by blindman
"...unit price of a product is not determined from the same tables as the unit price of equipment rentals or sub contract work..."
...maybe it should be. Maybe they should all be stored in a common table with a field to specify the type of transaction.
Unfortunately it cannot be. There are many factors stored on other tables and price lists that influence the price of the product; and there is only a single vendor/price list for any additional costing items.
The above is the basic table structure that generates the cost of products. In the take off, the user will select the template id, the cost of
the product is determined based on a quantity entered inthe takeoff. The template materials table you see above is the can generate the cost / unit mesure. If the product is costed by Square Feet, Linear Feet, etc....
The price list for everything else isn't nearly this intricate:
EntryID | Company | CategoryID | Price | ......