Re: Populate Details Forms4.5

Sri,

Since navigation is restricted, using a Timer is an option.

Set the timer at the end of validation, expiring in 1 millisecond. Create a When-Timer-Expired trigger that populates the detail block, ie. navigate to the detail block and issue Create_Record for each row required. If you're populating the detail block based on values returned by a cursor, keep in mind the master record won't yet exist in the database (unless it's already been committed).

srijay_at_my-dejanews.com wrote in article <72eiv9$m4g$1_at_nnrp1.dejanews.com>...
> Hi!
>
> I have a Master/Detail relation ship on a form. I would like to populate
> detail block with many records when a master record is created. The way
I
> would like to do this is, by go to the master block hit insert key
created a
> new record. At the end of validation in when-validate-record trigger I
would
> like to populate the detail block with many records programmatically (not
> insert to the database just the screen block). When the user hit the save
> button master and all the details will get saved to the database. Is
this
> possible?
>

> Any help would be appreciated.
>
> Sri.
Received on Fri Nov 13 1998 - 04:44:03 CET