Ciao Marty,
thanks for your suggestion, it is precious and it works
but, I discovered one thing, which messed up the whole attempsts I made
before.
The code I worked out were 2 fields, primary code and secondary code ... say
A and B (A= 3 digits and B=2 digits)
Then I made a compounded code (calculated, numeric result) = A&B
and it didn't worked - and all my attemptes were spoiled by that error even
if, looking at the result it seemed normal.
Lastly I made FINAL CODE = (A*100)+B
But no relation was working with that calculated code, so I had to modify my
relations
Instead of
Category::CalculatedCode <-> Book::CalculatedCode.
I had to make it this way:
Category::CodeA <-> Book::CodeA
and
Category::CodeB <-> Book::CodeB
And it's ok in all ways I intend to use portals and fields and etc etc.
and, with the relatin and calculated field in category table as you
suggested, now Works !!!
So I was suprised that the simple A&B did'nt worked either indeexed or not.
Hope this helps other with similar componded code problems even if I do not
make up my
mind why it needed to be a calculation like FINAL CODE = (A*100)+B
Well, anyway the problem is solved,
Thanks to all
MoneyMaker
----- Original Message -----
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, September 22, 2008 4:13 AM
Subject: Re: Portal count
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" =
