Relationship Question

[Aaron Woitkovich]

Experts,
 
I am trying to create a "Name" lookup function between two databases.
 
The first file is called Attendee Input and the second file is called
Site Coordinator.
 
What I am trying to accomplish is:
 
a user enters data into a Name_G global field in the attendee input
file.  I would prefer if they could enter "Aaron" and the portal below
would show all records that contain "Aaron" in them.
 
So a successful return would yield:
 
Aaron
Aaron Woitkovich
Tommy Aaron
 
etc....
 
 
Currently, the Site Coordinator Name is just one field.  So there are no
separate first,middle, last name fields.  So, if the Search String
appears in any portion of the Site Coordinator::Name field, I'd like the
result to display in the portal below.
 
I have it functioning based on Firstname using a calc in Site
Coordinator Leftwords(Name, 1) but if I can do that, I should be able to
find a way to do all?
 
Thanks,
Aaron
 
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[bfr00]

> Experts,
>  
> I am trying to create a "Name" lookup function between two databases.
>  
> The first file is called Attendee Input and the second file is called
> Site Coordinator.
>  
> What I am trying to accomplish is:
>  
> a user enters data into a Name_G global field in the attendee input
> file.  I would prefer if they could enter "Aaron" and the portal below
> would show all records that contain "Aaron" in them.
>  
> So a successful return would yield:
>  
> Aaron
> Aaron Woitkovich
> Tommy Aaron
>  
> etc....
>  

What version of FileMaker?
This is easier with the new script triggering available in Filemaker 10.


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Mark Rubenstein]

>
> a user enters data into a Name_G global field in the attendee input
> file.  I would prefer if they could enter "Aaron" and the portal below
> would show all records that contain "Aaron" in them.

Aaron;

You need to get all the words in the name field separated by returns,  
to form a multikey.
So, for instance, a record with the name Aaron Woitkovich would have  
this in the key field:

Aaron
Woitkovitch

A record with Tommy Aaron in the name field would have this in the key  
field:

Tommy
Aaron

The you can just match you global to this field.

One way to do this would be to create a calc field (with a text  
result) that simply substitutes returns for spaces, like this:

Substitute ( Name ; " " ; PP )

where PP is the pilcrow character.


Mark
--
Mark Rubenstein
Easy As Pi | [hidden email] | www.easyaspi.com

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Salman Maidan-3]

Aron,

If you have FMP10 then visit Ray Cologons site of NightWing Enterprises,
have a look at his instant search demo, the best I have seen :-)

http://www.nightwing.com.au/FileMaker/

Regards
Salman


On Wed, Jun 24, 2009 at 12:21 AM, Aaron Woitkovich <
[hidden email]> wrote:

> Experts,
>
> a user enters data into a Name_G global field in the attendee input
> file.  I would prefer if they could enter "Aaron" and the portal below
> would show all records that contain "Aaron" in them.
>
> So a successful return would yield:
>
> Aaron
> Aaron Woitkovich
> Tommy Aaron
>
> etc....
>
>
> Thanks,
> Aaron
>
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Aaron Woitkovich]

 
Experts,

Thanks for taking the time to respond.  Mark, your technique worked like
a charm in my FMP9 solution.  We are not using FMP10 currently, but I
will be sure to archive Salmon and Bruce's suggestion for later usage.

Again,  thank you to all.

-Aaron


-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Salman
Maidan
Sent: Wednesday, June 24, 2009 4:29 AM
To: [hidden email]
Subject: Re: Relationship Question

Aron,

If you have FMP10 then visit Ray Cologons site of NightWing Enterprises,
have a look at his instant search demo, the best I have seen :-)

http://www.nightwing.com.au/FileMaker/

Regards
Salman


On Wed, Jun 24, 2009 at 12:21 AM, Aaron Woitkovich <
[hidden email]> wrote:

> Experts,
>
> a user enters data into a Name_G global field in the attendee input
> file.  I would prefer if they could enter "Aaron" and the portal below

> would show all records that contain "Aaron" in them.
>
> So a successful return would yield:
>
> Aaron
> Aaron Woitkovich
> Tommy Aaron
>
> etc....
>
>
> Thanks,
> Aaron
>
>

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au