March 11, 200718 yr Newbies 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?
March 11, 200718 yr 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!
March 11, 200718 yr 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
Create an account or sign in to comment