Script problem

#11

Per Rønne wrote:

Quote:

Ursus <ursus.kirk (AT) ziggo (DOT) nl> wrote:

I just don't see a command that will take the primary key in the detail
table and use that as an argument in statements that will open another
layout with the detail table in the record with that primary key.

Enter Browse Mode[]
Set Fiels [Notitser::#;$n]
Perform Find[]

Instead of Enter Brose Mode[], sure you mean Enter Find Mode[]?

This last one should otherwise work. Are you sure there is a value in $n
before entering find mode? Are you sure that neither the Enter Find
Mode nor Perform Find steps have the restore option marked?

#12

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote

Quote:

Ursus <ursus.kirk (AT) ziggo (DOT) nl> wrote:

The OP might need to change the TO because he/she wants to show
different
related items.

"Per" is a Scandinavian short form of "Peter"; I'm a "he" :-).
--
Per Erik Rønne
http://www.RQNNE.dk
Errare humanum est, sed in errore perseverare turpe

The middle name of "Erik" shows that.

Helpful Harry

)

#13

Your Name <your.name (AT) isp (DOT) com> wrote:

Quote:

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote in message
news:1jgg3d2.ozk3u619r5kzxN%per (AT) RQNNE (DOT) invalid...
Ursus <ursus.kirk (AT) ziggo (DOT) nl> wrote:

The OP might need to change the TO because he/she wants to show
different related items.

"Per" is a Scandinavian short form of "Peter"; I'm a "he" :-).

The middle name of "Erik" shows that.

That one too.

My parents wanted to give me a first name that was the same as my
initials - they succeeded.
--
Per Erik Rønne
http://www.RQNNE.dk
Errare humanum est, sed in errore perseverare turpe

#14

Howard Schlossberg <howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Quote:

Per Rønne wrote:
Ursus <ursus.kirk (AT) ziggo (DOT) nl> wrote:

I just don't see a command that will take the primary key in the detail
table and use that as an argument in statements that will open another
layout with the detail table in the record with that primary key.

Enter Browse Mode[]
Set Fiels [Notitser::#;$n]
Perform Find[]

Instead of Enter Brose Mode[], sure you mean Enter Find Mode[]?

Of course.

Quote:

This last one should otherwise work. Are you sure there is a value in $n
before entering find mode? Are you sure that neither the Enter Find
Mode nor Perform Find steps have the restore option marked?

It now says:

Set Variable[$n; Value:Nototser::#]
Go to Layout["Notitser" (Notitser)]
Enter Find Mode []
Set Field [Notitser::#;$n]
Perform Find/Replace [No Dialog]

It now works almost as intended. It just still demands the user to press
the ENTER og RETURN key before performing the find ?
--
Per Erik Rønne
http://www.RQNNE.dk
Errare humanum est, sed in errore perseverare turpe

#15

Howard Schlossberg <howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Quote:

Per Rønne wrote:
I just don't see a command that will take the primary key in the detail
table and use that as an argument in statements that will open another
layout with the detail table in the record with that primary key.

If you are going from your single-record display table to your detail
table (which is what it sounds like to me), there is already a
relationship there...so you can just use the Go To Related Record step
based on the same relationship as you already use to display the detail
record in the display table. On this same step, you can specify which
layout you want to use for the detail record's context or display. You
can specify any layout based on that same underlying table (regardless
of table occurrence on the relation graph).

Ursus also provide a perfectly acceptable solution: to grab the detail
record's primary key/ID, go to the desired layout and perform a find for
that ID.

That is exactly what I have been trying to do all the time.
--
Per Erik Rønne
http://www.RQNNE.dk
Errare humanum est, sed in errore perseverare turpe

#16

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote

Quote:

It now says:

Set Variable[$n; Value:Nototser::#]
Go to Layout["Notitser" (Notitser)]
Enter Find Mode []
Set Field [Notitser::#;$n]
Perform Find/Replace [No Dialog]

It now works almost as intended. It just still demands the user to press
the ENTER og RETURN key before performing the find ?

That is usually caused by accidently leaving the "Pause" option turned on
for either the Enter Find Mode command or the Perform Find command.

Helpful Harry

)

#17

Your Name <your.name (AT) isp (DOT) com> wrote:

Quote:

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote in message
news:1jggow8.1uiwf4i1ndfnl8N%per (AT) RQNNE (DOT) invalid...

Set Variable[$n; Value:Nototser::#]
Go to Layout["Notitser" (Notitser)]
Enter Find Mode []
Set Field [Notitser::#;$n]
Perform Find/Replace [No Dialog]

It now works almost as intended. It just still demands the user to press
the ENTER og RETURN key before performing the find ?

That is usually caused by accidently leaving the "Pause" option turned on
for either the Enter Find Mode command or the Perform Find command.

The Enter Find Mode is without the Pause option turned on.

But I now see I should had used "Perform Find []" not "Perform
Find/Replace [No Dialog]". It now works as intended.

Thank you for your help.

BTW. "Perform Find" has no "Pause" option.
--
Per Erik Rønne
http://www.RQNNE.dk
Errare humanum est, sed in errore perseverare turpe

#18

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote

Quote:

Your Name <your.name (AT) isp (DOT) com> wrote:

"Per Rønne" <per (AT) RQNNE (DOT) invalid> wrote in message
news:1jggow8.1uiwf4i1ndfnl8N%per (AT) RQNNE (DOT) invalid...

Set Variable[$n; Value:Nototser::#]
Go to Layout["Notitser" (Notitser)]
Enter Find Mode []
Set Field [Notitser::#;$n]
Perform Find/Replace [No Dialog]

It now works almost as intended. It just still demands the user to
press
the ENTER og RETURN key before performing the find ?

That is usually caused by accidently leaving the "Pause" option turned
on
for either the Enter Find Mode command or the Perform Find command.

The Enter Find Mode is without the Pause option turned on.

But I now see I should had used "Perform Find []" not "Perform
Find/Replace [No Dialog]". It now works as intended.

Thank you for your help.

BTW. "Perform Find" has no "Pause" option.

Oops! You're right. I was thinking of the "Restore" option that is in both
commands.

Helpful Harry

)