Calculate field using different field from different table

[k31453]

So i have got this table

Table 1:-- List of available classes

Design view

Class -- Primary key ---text

Subject ----text

Num. Lessons---- Number

Enrolments ---- Number

Max Class Size--- Number

Action -- Calculated because if enrollment is higher then max. class size then its says full otherwise it will tell enrol




Table 2:-- Teacher And Class Income



Class --- text

enrolment --- number

max class size ---- number

income per enrolment ----- currency

incomer per class ----- currency ???



1) BUT WHAT I WANNA DO IS IF I CHANGE ENROLLMENT and max class size VALUE IN TABLE 1 ... I WANT THAT CHANGE IN TABLE 2 ENROLLMENT and max. class size FIELD AS WELL

For e.g. if i change enrollment =25 and max class size = 30 ,,, i want that change in table 2 .......so i want that table 2 should display Enrollment = 25, max class size = 30

I want this things in TABLES not queries so can anybody tell me please what should i do... and i compulsory have to use access... NOT EXCEL

2) then i want that Total Incomer per class (In Table 2) = Enrollment * Income per enrollment so that value should be display on total incomer per class ....

So if i change enrollment value ... then the total income per class value has to change ....

3) i want in table that my total income in all class should display in same table ( Table 2)

I am attaching some files that might can help you.. and i need this done in this 3 days .. so please

[June7]

You are duplicating data. The enrollment and class size should only be in List table. The data can be retrieved by query join of tables. Otherwise, will need to run UPDATE sql action to modify data in other table.

[k31453]

So How Do you do It ????/

So i have got this table

Table 1:-- List of available classes

Design view

Class -- Primary key ---text

Subject ----text

Num. Lessons---- Number

Enrolments ---- Number

Max Class Size--- Number

Action -- Calculated because if enrollment is higher then max. class size then its says full otherwise it will tell enrol




Table 2:-- Teacher And Class Income

Class --- text

enrolment --- number

max class size ---- number

income per enrolment ----- currency

incomer per class ----- currency ???



1) BUT WHAT I WANNA DO IS IF I CHANGE ENROLLMENT and max class size VALUE IN TABLE 1 ... I WANT THAT CHANGE IN TABLE 2 ENROLLMENT and max. class size FIELD AS WELL

For e.g. if i change enrollment =25 and max class size = 30 ,,, i want that change in table 2 .......so i want that table 2 should display Enrollment = 25, max class size = 30

I want this things in TABLES not queries so can anybody tell me please what should i do... and i compulsory have to use access... NOT EXCEL

2) then i want that Total Incomer per class (In Table 2) = Enrollment * Income per enrollment so that value should be display on total incomer per class ....

So if i change enrollment value ... then the total income per class value has to change ....

3) i want in table that my total income in all class should display in same table ( Table 2)

I am attaching some files that might can help you.. and i need this done in this 3 days .. so please

[June7]

Do which? Table join or UPDATE action?

I would not do the UPDATE. It is unnecessary duplication of data.