portal hell

I'm trying to do everything by table relationships as opposed to value
lists, but I'm running into trouble when it comes to keywords

I have three databases (table):
Organizations---Contacts---Keywords

Instead of doing the traditional One name, one record thing, I'm using
the Organizations as the main record that can be assigned an unlimited
number of contacts at that organization through a defined relationship
between tables

I want to assign keywords to each contact, like "main contact" or
"publicity contact" or "cc contact" or "lead contact on xxx project,"
and I want each contact to be able to have multiple keywords attached
to them, and this is no problem doing it though a defined relationship
between tables

Where I'm running into problems is in displaying all of this within
the Organizations database

I have one portal that links to that Organizations contacts...it's a
portal that's large enough to display that contact's phone number and
email addresses, much like a rolodex card

But I also want to display that contact's keywords, but I can't find a
way to get the keywords into a field so I can show it, or do a portal
within a portal kind of thing...

I think I may have made this database past the limits of what
filemaker can do, but I'm not sure...does anyone have any ideas?

Thanks

David Averbach

Re: portal hell

What version of Filemaker?

David Averbach wrote:
> I'm trying to do everything by table relationships as opposed to value
> lists, but I'm running into trouble when it comes to keywords
>
> I have three databases (table):
> Organizations---Contacts---Keywords
>
> Instead of doing the traditional One name, one record thing, I'm using
> the Organizations as the main record that can be assigned an unlimited
> number of contacts at that organization through a defined relationship
> between tables
>
> I want to assign keywords to each contact, like "main contact" or
> "publicity contact" or "cc contact" or "lead contact on xxx project,"
> and I want each contact to be able to have multiple keywords attached
> to them, and this is no problem doing it though a defined relationship
> between tables
>
> Where I'm running into problems is in displaying all of this within
> the Organizations database
>
> I have one portal that links to that Organizations contacts...it's a
> portal that's large enough to display that contact's phone number and
> email addresses, much like a rolodex card
>
> But I also want to display that contact's keywords, but I can't find a
> way to get the keywords into a field so I can show it, or do a portal
> within a portal kind of thing...
>
> I think I may have made this database past the limits of what
> filemaker can do, but I'm not sure...does anyone have any ideas?
>
> Thanks
>
> David Averbach

Re: portal hell

Sorry

8.5 Advanced
Mac OS 10.5

Re: portal hell

On Mar 30, 3:43 pm, David Averbach wrote:
> Sorry
>
> 8.5 Advanced
> Mac OS 10.5

Filemaker doesn't permit a portal within a portal, but you can create
an unstored calculation field in Contacts=3D

List(Keywords::Word)

And display that. You can manipulate that field as you want, say by
making it=3D Substitute(ListKeywords::Words); =B6; ", ")
to get the words flat rather than a list.

And you can put the calculation in a Tooltip.

Re: portal hell

Wow...
I have never used the List command before! Awesome, it works
perfectly, thanks.
David