Hi Lombardia44, Add one relationship between the Category and the Book tables, if not already existing: Category::CalculatedCode <-> Book::CalculatedCode. Lets call it "CategoryToBook"
Add one calculated field in the Category table: Count(CategoryToBook::CalculatedCode). Let's call it "BookCount" Display the new field, BookCount, on the Category record in the portal. Ciao. Marty Cohen [EMAIL PROTECTED] -- John Weinshel <[EMAIL PROTECTED]> wrote: Not responding to the content of your post, but I have changed the subject line to something more likely to solicit results. John Weinshel Datagrace Vashon Island, WA (206) 463-1634 Member, FileMaker Business Alliance Certified For FileMaker 8 Certified For FileMaker 7 -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Lombardia44 Sent: Friday, September 19, 2008 2:20 PM To: [email protected] Subject: Portal cunt Ciao to everybody, I have a database of books that I have classified with some sort of a Dewey system (modified by me) there is (on a table) a master code , like ANIMALS, 100 and a secondary code, like: DOGS, 10, CATS 20, lizards 30 et al. So the final calculated code is 10010 or 10020 or 10033 and so on. There is in the books layout a portal that shows all categories of the Dewey table. What I need is to show, in the portal, how many books are already categorized with that code. I tried but with no results. Anybody willing to help? MoneyMaker - Italy ( fmp 7 and Windows Vista ___________________________ "The Plain Art of Making Money"
