asked
Update field or fields value in one table from another table
I have created a database with two tables so far. One table named MenuItems and the other named PriceImport. Bothe items have the same fields PLU(primary Key in both), Description, Size, Cost, Price. What I am trying to do as a beginner in SQL is to learn how to make the prices I export into the Table: PriceImport update the Price in the MenuItem the minute they are exported in the presence of the primary key. I don't know how to do this but I know many members here are SQL masters and will appreciate learning from you all. I am trying to learn sql one step at a time but my eventual goal is to attempt to make a form that would run in Windows Mobile 5.0 or Pocket PC environment that I can use to collect data and sent directly to my sql database BUT for now I taking multiple routes to get to my database starting with an excel table in my handheld device and exporting it to MS access 2007 then linking a table there to sql table named PriceImport and got stuck there. Help is appreciated
Is MenuItems a table in MS Access 2007? And is PriceImport is a table in a SQL Server database?
It sounds like you want to have a trigger. [Here's the Books Online entry for that][1]. You want a Data Manipulation Language (DML) trigger. [1]:
http://msdn.microsoft.com/en-us/library/ms189799.aspx
16 People are following this question.
