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, 12:00 AM
By Robert G in forum .NET
Last Post: 02-08-2001, 02:38 PM
By Todd B - Agendum Software in forum vb.announcements
Last Post: 09-13-2000, 10:18 AM
Tags for this Thread
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL