Hi! Can anyone please provide me with a little bit of information regarding this subject? I think I've heard from a lecturer that there is a command to auto-update the entries of a table. For example, when a new record is inserted, the salary column would be auto-inserted with (rough_salary - tax_rate) without having the user to key in the salaries. In case, it is trigger you are thinking of, I don't think that is it. Anyone get me? Thanks.
Well to my knowledge of SQL or Access for that matter. It would be a trigger that does something like that. There is no other way to update a column automatically via a calculation without using a trigger.
So I would be extremely surprised that there is another way. Stored Procedures or Triggers is the only method I know of.
Umm...thanks a lot anyway. Actually, I am supposed to create a data warehouse. Knowing that data warehouse has all the following characteristics: non-volatile, time variant, integrated, subject-oriented; which is why trigger was not allowed by my lecturer.