i have 2 questions:

i am in the process of creating a databse of archival material in a museum. one of my fields is "category," which has a number of possible entries (e.g., tourism, current events, antiquities, etc.)

1) when a do a find search in category i would like to save the found set as a separate layout in the main file, or something similar, so that i don't have to keep doing the find command. is this possible?

i also have a "period" field which i've set up as a date field. a lot of the material is from newpapers, so i have a full date (e.g., june 7, 1977), but for others the date is unknown, or i only have the month and year.

2) is there a way to set this up so i can sort by period and have the month/year entries fall in the appropriate place, with the unknowns at the end? also, using the date field doesn't display the month/year and unknown entries properly - how do i fix this?

thanks very much for any and all help!!

magnuna

ps - i checked out the following link, but unfortuntaely don't have a program to open the attached files - which may tell me what i need for the 1st question

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB31&Number=155023

Saved searches isn't particular beginners stuff, but indeed posible:

http://previews.filemakermagazine.com/videos/544/SavedSearches_full.mov

--sd

Hi magnuna,

You said:

... unfortuntaely don't have a program to open the attached files ...

The files are in Zipped format 99% of the time and can be opened by a couple of different programs including Stuffit Expander. You can download a free copy of Stuffit Expander from several sites, HERE is allume's site

HTH

Lee

oi! you weren't kidding. this may be more difficult than it's worth, but if i can figure out the whole writing scripts part, then it would be awfully useful.

thanks for the link!