Data Dependency - Automatic Updation

[Waheed2008]

Hi all,
Sorry for bothering again
I have got another problem.I have two tables Department and Expenses.

Department has the following fields:
ID, Name, Budget

Expenses has the following fields:
ID, InvoiceNo, Department, Budget, Expense, Description, etc.

I have designed a form for Expense table which has a ComboBox populated with names of department from Department. When we select any department, the corresponding budget (from Department) is filled up into text box in this form. These form fields are then saved into Expense table.

Now the problem is that, when there are about 1000 entries in Expense table, for a given department, and we change budget value in Department table, how can this budget value can be updated into Expense table?

What is the easiest way of doing that?

This is a sample situation. I ll adjust the method into my project.

I 'll be realy very thankful for any response.
Regards

 

[boblarson]

The best way is to follow normalization rules and NOT store it twice. If you have it in one place, that is all that is necessary. If you need it for something else, then you use a query with the appropriate tables linked together to get the value.

 

[Waheed2008]

Thanks for Valuable guidance. I ll try to normalize my database and shall bother you again if I face some problem.
Thanks again