I am need to script for the following

From a current form with customer id, goto report layout with the current record.

ANd generate a portal containing the product that customer purchase but only with the same purchase date.

I came up with

Set Field ["gobal date", "Purchase date"]

Go to layout{Refresh window, "Purchase Form"]

Enter Find Mode[]

Set Field["Status", "Purchase"]

New Record/Request

Set Field["Date", "Purchase date"]

Perform Find[Replace found Set]

Some how its not getting the date right, its return all the purchase with different date.

Any Clues

Hi -

Try changing your Set Field date inside your find to that of the Global Date instead of the Purchase date. Remember you are in a find mode, so the field is empty. I assume that is why you are using a global date field.

HTH

Sorry I made a typo mistake, it should have been gobal date instead of purchase date.

Set Field ["gobal date", "Purchase date"]

Go to layout{Refresh window, "Purchase Form"]

Enter Find Mode[]

Set Field["Status", "Purchase"]

New Record/Request

Set Field["Date", "gobal date"]

Perform Find[Replace found Set]

I have a portal using a relationship from a

calculation field thats made up of

customer id & purchase date