Sort Chooser

[jimmy176]

I have clients and projects. I have a layout that looks good, and about a million scripts to display each combination of clients and projects.

My script is basically:

show all records //to clear previous find//

perform find Client=201 //limits to client 201//

constrain found set project=1 //shows project 1 of client 201

The problem is, I have to duplicate and edit this script for each project and each client (currently 26 clients x 3 projects = a boat-load of nearly identical scripts)

I'd like to go to my layout, and choose which client, and which project to display in the layout.

My clients are numbered, 201,202, 203, etc... and there are exactly 3 projects for each client. The projects are all numbered the same way, so I was thinking of a drop down that pulls records from the client list, then 1,2,and 3 radio buttons for the projects. This would then display one set of records from a single product ID. Is this possible?

[mz123]

create two global fields:

globClient

globProject

Each one can have drop downs for your clients and then projects for the selected client.

Create a script as follows:

Enter Find Mode

Set field "Client" to globClient

Set field "Project" to globProject

Perform Find

That should do it!

[Lee Smith]

Wouldn't this be easier with a Relationship and a Portal?

This sounds like you are going to a Client Record, and then wanting to see the projects for the Client.

Lee