Guidance needed for a project
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.
Moved From Talk To The Editors which is a section for threads relating to the DevX web site in general.
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
By Gary Nelson in forum .NET
Last Post: 10-01-2003, 01:00 AM
By Robert G in forum .NET
Last Post: 02-08-2001, 03:38 PM
By Todd B - Agendum Software in forum vb.announcements
Last Post: 09-13-2000, 11:18 AM
Tags for this Thread
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center