Hi,
I am a form which has a sub form,
The sub form is linked with primary key of main form as a foriegn key
in sub form, very basic,
In the main form, I have another field which is investor, and in the
sub form, I have created investory foreign key, this is the second link
between main form and subm form.
When i first enter the record, both the primary keys are updated in the
sub form and it works fine.
However, if later I have to go adn change the investor (which is a
requirment) the forien key in the sub form do not get updated, it still
show old invenstory.
May be one way of doing is to have an event procedure, on the after
update of investory field in the main form, which should go to sub form
and update the investory foreign key to correct investor.
Can someone please help me with sample code? or sugguest a better way
of doing this.
Thanks and Regards, Irf.
I am a form which has a sub form,
The sub form is linked with primary key of main form as a foriegn key
in sub form, very basic,
In the main form, I have another field which is investor, and in the
sub form, I have created investory foreign key, this is the second link
between main form and subm form.
When i first enter the record, both the primary keys are updated in the
sub form and it works fine.
However, if later I have to go adn change the investor (which is a
requirment) the forien key in the sub form do not get updated, it still
show old invenstory.
May be one way of doing is to have an event procedure, on the after
update of investory field in the main form, which should go to sub form
and update the investory foreign key to correct investor.
Can someone please help me with sample code? or sugguest a better way
of doing this.
Thanks and Regards, Irf.
Comment