Cascade update

[axslearnr]

Hi
I have two tables OOS and OOS_EXT. I jsut want to enter the data in the OOS table and fill the OOS_EXT table from the OOS table realted columns. After that I want to yse casecade update so that if i make any changes in the OOS table it should reflect in the OOS_EXT table. IF i make changes in The last field of table OOS_EXT which is Reviewed By field it should be updated for that field in OOS table. IS there anyway I can do that? Please let me know
thanks.



OOS OOS_EXT
-----------------------------------------
OOS_ID (Autonumber) OOS_ID
Product (Text) TA/PA (Text)
Sample Number (Text) Date of completion (Text)
TA/PA (Text) Response person. (Text)
Date of completion (Text) Reviewed By (Text)
Response Person (Text)
Reviewed By (Text)

 

[PHV]

Why trying to keep in synch unnecessary fields ?
Replace your OOS_EXT table by a query.
I'm missing something ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[axslearnr]

hi
thansk for ur reply. But i need to able to enter information in reviewed by field in the OOS_EXT table. will i be able to do that by query.
and it also should update in the OOS table.

let me know

thanks

 

[PHV]

The basic question is: why 2 tables if they should keep sync ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[axslearnr]

hi

Well I dont really need OOS_EXT tabe its just it needs to pull information from OOS table not all the fields as someones wants to see those and signed in the Reviewed By field and it should get updated in the OOS table.
thanks
pls let me know

 

[PHV]

Why not just building a form bounded to OOS with only the relevant fields, not allowing addition nor deletion ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244