update a table depending upon the data in another table

[Fahim]

I have two tables tblStudent having fields AdmissionNo,
Class, Section and another table tblresult having fields
AdmissionNo, sub1, sub2, sub3, result(pass or fail).
i want that when i enter the data in tblresult the class
field of tblStudent should be updated if the result field
in tblresult has the value pass.

 

[Eric Butts]

Hi,

You can create an Update Query that does that. Inner Join the two tables
based on "AdmissionNo" (I guess) and after you finish updating the records
in the table "tblresult" run the Query.

You can get sophisticated with it where you have a Form that is bound to
the table "tblresult" and after each time you update a record or add a new
one you would programmatically call the Query to run.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support