AnsweredAssumed Answered

Set Field to (Find it)

Question asked by BetoBoton on Jul 24, 2009
Latest reply on Jul 30, 2009 by BetoBoton

Title

Set Field to (Find it)

Post

Hi 

 

I'm a "novice"  with FMP, and I'm on a Mac with FMP 9 Adv. so please be aware of possible silliness in my questions.

 

 

Using the ready made Business Solution for Services from FM, and specifically the contacts.fp7 I'm trying to create a new Text field called "Referrer" which is the "Full Name" ("First Name" + "Last Name") of the same record (self referred) OR here comes the question:

 

I need to  FIND, in the SAME contacts Table  a contact record via First Name field and/or Last Name field to fill this field.

 

(This means the person who referred this client, must be a previous client or it is mandatory to be "self-referred" 

 

I have no idea where to start.

Any suggestions that would point me to  perform a "find script" starting with the letters I type into the field in the contact form. 

Do I need to create this find in a "new dialogue or window" ? 

 

My learning style is by example - does someone knows of book, blog or any other place where I can find an example/explanation of finding something while inserting new data in browse mode...

 

Thanks a lot for any help (I'm lost...)

 

Beto Boton 

 

Outcomes