Hi all,
I am new to access and databases so I mis lot of concepts that should be
kept
in mind while working of some project.
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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200808/1
|
