How to make to update data in related Tables? (1 Viewer)

[preetbilkhu]

Hi, I have to make a Costing System but for that I need to enter our Expense details in database according to Fiscal year and months.
I need a table for Fixed expenses and one for Variable Expenses and then I need one or more Forms to update data in those tables. Now I've created a table with Fixed Expenses. I have to update Year and Amount in that. Now it is only letting me one entry per Expense. I want multiple entries for one Expense say 'Advertising' for different years.
Please help me in that. I'm thinking may be I need to make more than one Table, may be one for Expenses with ExpenseID and other for Years with Year and YearID and the third one for Amount with columns Amount, Method of Payment, Date and Notes. I did tried this but I think I'm not creating proper relation may be because its only updating for one year.
I'm using Access 2003.

 

[Mihail]

First of all seems that you need to understand very well this:
Database Normalization and Table Structures - Microsoft Access / VBA

Second... No. Is no need to have 2 tables for "expenses".
Use a single table but add one more field "IsFixedExpens" (or IsVariableExpens) of type Yes/No and fill it as needed.

 

[preetbilkhu]

Thank you Mihail. I will read the link and see if that helps.