Guidance needed for a project


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Guidance needed for a project

  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Question Guidance needed for a project

    Hello -

    I am not sure what would be the best way to handle this so I thought I would start here and see what you might suggest.

    I have an Access database that houses a price list; the price_table contains two fields: product_tag and product_price.

    Then I have an Excel worksheet that is used to create quotes for our customers. There is a column titled 'Type' in the worksheet that is the same as the product_tag field in the database. There is also a column titled 'Amount' that is the same as the product_price in the database.

    What I need to do is when the user enters the 'Type' in the Excel worksheet cell have the product_price from the database automatically fill in the 'Amount' cell in the worksheet.

    So, if the user enters HD-1 in the 'Type' cell in the worksheet it would automatically search the price_table and find the matching HD-1 row and update the 'Amount' cell in the worksheet with the information in the product_price field.

    There could be multiple Types entered on the quote so we would need it to be able to do this process for each Type the user might enter.

    I do not know what the best method would be to run this process so any info you can provide me will be a great help.

    Thank you,

    QuickStudy

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Moved From Talk To The Editors which is a section for threads relating to the DevX web site in general.

Similar Threads

  1. Control Arrays in VB.NET
    By Gary Nelson in forum .NET
    Replies: 277
    Last Post: 10-01-2003, 01:00 AM
  2. Good Editorial by Russell Jones
    By Robert G in forum .NET
    Replies: 84
    Last Post: 02-08-2001, 03:38 PM
  3. Replies: 0
    Last Post: 09-13-2000, 11:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center