Yesterday I learned how to construct a portal to show only records from the current year. I created a calc field - Date (1;1;year (GetCurrentYear))) and then created a new table occurrence called "Current Year". Creating a relationship non-equious join (equal to or greater than) between the Orders file to the Patron file (with the calc field in the patron file), the portal shows all the orders for this year.
Very cool. [Thanks to the Love, Lane and Bowers book, "Using FileMaker 8"]. But I work at a school and our academic year goes from July to June, which covers two years. I'm not sure how to even start to construct a portal that will show orders from 7/1/2006 to 6/30/2007. I just can't figure out where to start. Can someone get me started? Deb Deborah Tinsley Assoc. Librarian of Visual Resources Kansas City Art Institute [EMAIL PROTECTED] 816 802 3395
