This question is more about development but I can't seem to find much help anywhere. I have the missing manual and have consulted it and still can't find my answer. I used to use ACT for PC and now that I have a Mac have switched the FileMakerPro. What I want to do is be able to open one database that has 12 databases in it and variable number of datebases within that. Basically, I have several events a month, and each even has a different guest list. What I want to do is make this interface userfriendly and clean. I want to open a file, say one labeled 2012. Within 2012 I want 12 months. In each month I have at least 10 events and each event has at least 6 guests. My biggest problem is that I don't want to look at everything at once. I want them to be like folders within folders, but need the datebase to be able to perform a search function that can search throughout each folder. ACT could do this. How can I make my filemakerpro look more like a filing cabinet and less like a giant spread sheet where I have to search by 3 different criteria to find what I want?
Any help would be appreciated.
Email me at firstname.lastname@example.org