checking if the value is in the field?

[Anh_Tran]

Hi All,

I have a field named Name_Student:

record 1 : Bob

record 2: Chris and so on....

so I have a layout which have a global field named Check_Name ...when I enter : AnhTran.... how do I know that the name is exits in the field Name_Student or not and how do I check if I enter is correct? ... Do I need to go through each record to c check??? ...that takes long? ...or do I use a valuelist to check it?

Anyone has an idea?

Thanks

Anh Tran

[cjaeger]

Arghhh Tran, "name is exits"(?)

so you want to check for an existing name, I guess. (btw. there IS a check spelling option for the posts, why not use it?)

Make a value list from related or self-join) file,

then set field validation to use that value list.

or better: if just a few students, use a drop down list.

otherwise, use the "clairvoyance" technique as shown at www.databasepros.com

[Lee Smith]

Hi Christian,

The spelling checker available here is weak, to say the least. It can't be trained and therefore words such as FileMaker continue to be suspects.

Hi Arghhh,

If I'm understanding you correctly, why not do a find in the field, using the correct spelling of course.

Lee

[Anh_Tran]

ihihhi

I used 1-1 relationship to check if the names is equal to other name of other database...

yeah do a find is good too ...

sometimes i find my head is stopping working....

Thanks All

Anh Tran