Thanks guys-

I have another related problem:

I have a main menu with 4 button choices:

Baseball, Basketball, Football, Wrestling-each button goes to a different layout-

I have over 3000 records in the entire database. Is there any way that when I select a layout it goes to the correct set of records- for each sport? Is there a checkbox that I can put in each record to specify the sport- and then have it search by this?

(So when I hit the baseball button it brings me to the baseball layout and shows the corresponding files)

Thanks again, hope you can help with this one!

-Christine

This seems to be a non relational structure with only one file and 4 layouts.

Create a global text field called gCategory.

Then create a self relationship YourFile:Category::YourFile:gCategory.

Then the button should trigger a script that is

Set field (gCategory=Category)

If gCategory = "Basketball"

Show related records (your relationship)

goto layout 1 (which is a subscript)

End if

If gCategory = "Football"

goto related records (your relationship)

goto layout 2 ....

Or simply

If Category = Basketball

Go to layout 1

Find Mode

Setfield Category = Basketball

Perform Find