I've got two databases..one with contacts and one with employment info.  In 
the contacts database I've put a portal showing the phone number from the 
employer database.  It works great, except I've got 70000 records and when I 
do a search it searches thorugh them all and because it shows they are 
unindexed it takes forever.  When I search in the current dbs in a field 
that is contained in the current dbs it is quick.

any ideas?

Why wouldn't you set the field to be indexed?

Matt

"Jay" <azuraboom@hotmail.com> wrote in message 
news:S6-dnbHEdIDzd0PcRVn-jg@look.ca...
> I've got two databases..one with contacts and one with employment info. 
> In the contacts database I've put a portal showing the phone number from 
> the employer database.  It works great, except I've got 70000 records and 
> when I do a search it searches thorugh them all and because it shows they 
> are unindexed it takes forever.  When I search in the current dbs in a 
> field that is contained in the current dbs it is quick.
>
> any ideas?
>
> 

because i can't index a portal that references a field in another database

"Matt Wills" <nospam@verizon.net> wrote in message 
news:zHDDd.1849$eb.50@trndny01...
> Why wouldn't you set the field to be indexed?
>
> Matt
>
> "Jay" <azuraboom@hotmail.com> wrote in message 
> news:S6-dnbHEdIDzd0PcRVn-jg@look.ca...
>> I've got two databases..one with contacts and one with employment info. 
>> In the contacts database I've put a portal showing the phone number from 
>> the employer database.  It works great, except I've got 70000 records and 
>> when I do a search it searches thorugh them all and because it shows they 
>> are unindexed it takes forever.  When I search in the current dbs in a 
>> field that is contained in the current dbs it is quick.
>>
>> any ideas?
>>
>>
>
> 

Portals don't reference fields.  Only fields reference fields and the
fields in a portal are still indexed just as they would be if you were
performing a Find on those fields in their home data table.  Perform
your Find on the related field.  There could still be issues with this
under certain circumstances, but 9 times out of 10 this should work for you.

Jay wrote:
> because i can't index a portal that references a field in another database
> 
> "Matt Wills" <nospam@verizon.net> wrote in message 
> news:zHDDd.1849$eb.50@trndny01...
> 
>>Why wouldn't you set the field to be indexed?
>>
>>Matt
>>
>>"Jay" <azuraboom@hotmail.com> wrote in message 
>>news:S6-dnbHEdIDzd0PcRVn-jg@look.ca...
>>
>>>I've got two databases..one with contacts and one with employment info. 
>>>In the contacts database I've put a portal showing the phone number from 
>>>the employer database.  It works great, except I've got 70000 records and 
>>>when I do a search it searches thorugh them all and because it shows they 
>>>are unindexed it takes forever.  When I search in the current dbs in a 
>>>field that is contained in the current dbs it is quick.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

My apologies.  It is actually a field referencing another field, not a 
portal (Yes it's been a long time since I've developed)

Any ideas?

"Howard Schlossberg" <howard@antispahm.fmprosolutions.com> wrote in message 
news:10u0cvtme2ke8da@corp.supernews.com...
> Portals don't reference fields.  Only fields reference fields and the
> fields in a portal are still indexed just as they would be if you were
> performing a Find on those fields in their home data table.  Perform
> your Find on the related field.  There could still be issues with this
> under certain circumstances, but 9 times out of 10 this should work for 
> you.
>
> Jay wrote:
>> because i can't index a portal that references a field in another 
>> database
>>
>> "Matt Wills" <nospam@verizon.net> wrote in message 
>> news:zHDDd.1849$eb.50@trndny01...
>>
>>>Why wouldn't you set the field to be indexed?
>>>
>>>Matt
>>>
>>>"Jay" <azuraboom@hotmail.com> wrote in message 
>>>news:S6-dnbHEdIDzd0PcRVn-jg@look.ca...
>>>
>>>>I've got two databases..one with contacts and one with employment info. 
>>>>In the contacts database I've put a portal showing the phone number from 
>>>>the employer database.  It works great, except I've got 70000 records 
>>>>and when I do a search it searches thorugh them all and because it shows 
>>>>they are unindexed it takes forever.  When I search in the current dbs 
>>>>in a field that is contained in the current dbs it is quick.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 883-2846
> FM Pro Solutions       Los Angeles, California
>
> FileMaker 7 Certified Developer
> Associate Member, FileMaker Solutions Alliance