I am linking to a SQL database and have a global field where the user enters the project they want to retreive records from and a script returns these records from the correct project entered only correctly.

Then if they do another specific find in a layout for a particular record associated with that project, this returns that particular record too because the project number was held in the global field. (I think )

My problem for the user is that after viewing this one record from the specific project, they now want to go back to the same layout where all relevant records for only that project again are displayed so they might choose another one to look at etc.

How do i create a button that will Show all Records for this project again but not Show All Records for All Projects which is happening to me.

Thanks in advance

Edited February 3, 200818 yr by Guest

Think this works

Enter Find Mode []

Set Field [ProjectNumber;GlobalField]

Perform Find []

Go To Layout [Layout]