Reliable data

[k31453]

Hi i have a Table 1:

That has Enrolment, Max class size

I got another Table

That has a same field

It has Enrolment, max class size

The data of both table is same ..but i need a expression so that

If i change the value in Table 1

Emplyee or Max class size


i want it automatically that value changes into Table 2 fields

which is Enrolment , Max class size

For e.g I change the value of Enrolment in Table 1 to 20 to 15 i want..
that same change in Table 2 Enrolment as well automatically

does anybody know how do u do it ??

 

[plog]

Databases shouldn't work like that, you don't store redundant data. Why have it in two places if the data should be the same? Why not store it in one place and just change it there?

My guess is you probably shouldn't even have 2 tables. Could you post the structure of both tables (i.e. field names, field types) and an explanation as to the purpose of each table?

 

[k31453]

My Table 1: List Of Available Classes

student id
Class
Teacehr Id
Subject ID
Subject
Description
Number of lessons
enrolment
max class size
action is Full OR available to enrol

Table 2 : Tutoring Income

Class
Teacher ID
enrolment
max class size
income per class


so i need enrolment and max class size in both table