Update Field Value in Subform

[Farzam]

Dear All,
I have a Main form and a Subform in it both forms are linked by a main ID which is CRIS_NO (int) both
master and child are the same CRIS_NO in main and subform.
now.
The main form contains information about a Contract
and the subform contains information of forecasted payments to be paid in the future
when I create a contract it is in the pipeline it is not an actual contract. it will have a fake ID
when i enter entries in forecast table it also takes that FAKE IDs from main form.. later on i want to change this fake ID to actual contract ID ...
--- the problem is that when I change the value in main form the subform also populated with a new value based on main form. ...
--- what i want is when i change the value in main form ...the ID in subform also should be changed to as new values in main form and the rest of entries in subform be the same ...
iam using SQL SERVER and ADP front.
regards,
farzam

 

[GingerR]

Hi--I think if you have your relationships set up properly, with Cascading Updates set on the two tables and their ID fields, this will work for you. Try it out.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Farzam]

GingerR.

That is great man ! it worked 100% thank you

For anyone who faces this problem please create relationship between main and sub table. and also important make sure cascade updates are on.
regards

farzam