Omitting Records from a columnar/list layout

[bideau]

I'm an FM newbie. Just feeling my way through the dark right now.

I'm using a script that I copied from a template to list all "client" records in a list layout. This is the script:

Allow User Abort[Off]

Show All Records

New Window[]

Adjust Window[Maximize]

Go to Layout ["SelectClientForModality"(ClientData)]

Sort Records[Restore;No Dialog]

Go to Record/Request/Page

some other lines not related to the layout

What I get on my layout is a list of all clients currently entered into the database.

I'm passing a script parameter which is a number. I'd like to omit any records if a specific client field matches this parameter. I haven't been able to figure this out.

Anyone have any ideas?

[Fitch]

One solution would be to create a new relationship from a global number field, let's call it gNumber, to the number in question, I'll call it clientNumber. Make the relationship based on NOT equal.

Now you can replace the script steps that show all, new window, adjust, go to layout with:

1. a step that sets gNumber to the number you want to omit, e.g.

Set Field( gNumber ; Get( ScriptParameter ) );

2. using your new relationship, Go To Related Records (show only related), where you specify new window, using layout, size, etc.