Shoot, still not right...

I'm probably just doing something wrong but...

I thought the answer on the earlier post from GUYK would solve my problem, but it didn't :

I went into the relationship graph and made sure that the box was checked for "allow creation of records in this table via this relationship" Anyway...

I have a Database with 2 tables:

Sales Order

Purchase Order

I have a script in Sales Order that when performed creates a new record in Purchase order and populates some fields. The Purchase order might not need to be accessed right away so the database "stays with" the sales order and displays a portal with the newly created Purchase Order number(s) that can be accessed by clicking the related portal row that has a script (and button) associated.

The databases are related by a uniqueID, and the portal displays the proper information with the following exception:

The portal does not update unless I bring the Purchase Order "forward" to be the "Active Window", click anywhere on the screen that is not a field, and then return to the Sales Order database.

Does this sound familar or is it just me? Is there a script step I might not be aware of, something fundamental?

Thanks in Advance for any help.

Steve

Edited December 13, 200520 yr by Guest

You probably need to use the "COMMIT RECORD[]" script step.

That is all it was! You guys rock!

Thank you, Thank you, Thank you!

Steve

Hi Steve,

Although this seems to have been solved now, Please post the link to the original questions so that others who come later, will be able to follow it to conclusion.

TIA

Thanks.

Hi,

Isn't it just my original post on the top of the thread? I'm sorry but I don;t understand what you are asking me to do.

Steve

What's the subject of your other post that you are eluding to in this one?

Below is the post I looked at to help solve this problem. Is this what you are asking me for?

Steve

========================================

Inky Phil

Loose cannon

Posts: 185

Loc: NW England

FMP: 7

OS: Windows XP

Skill: Intermediate

11/25/05 03:26 PM - Post#184285

In response to GUYK

GUYK

If you go to your relationship diagram and click on the relationship involved in your portal have you got the relevant box ticked that says 'allow creation of records in this table via this relationship'?

HTH

Phil