Results 1 to 1 of 1

Thread: still need help

  1. #1
    Join Date
    Apr 2004

    still need help

    Hello forum

    I am still struggling with my database design though I have narrowed down my problem. (I think)
    I am trying to build a quotation system where the user can select one or more base product (PIECE) and can then add zero or one or more products (ADDON).
    I have grouped together the add-on and base products together as they carry the same attributes. But the base product unit cost is measured by width and height while the unit price of add-on is based on quantity.

    Can I do that?

    The quote will also show 2 prices depending on the choice of paint. For example
    Option 1 plain paint = $50
    Option 2 metallic paint = $100

    These prices will vary depending on the customer type.

    How can I add that to my quote?

    Your help will be greatly appreciated.

    Attached Thumbnails Attached Thumbnails erdnew4.gif  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts