Help! How to search for a record using a valuelist

[Sir_Duck]

I want to use a value list to search for an id number from the filed id. In this case number 1.

 

I search and it shows the right record with id number 1, but every record that has number 1  in the filed for something else are listed to.

 

I only want the record with id number 1 to show up, and not the others with a number 1 in another filed. 

 

Can someone please help me with a script that mange to do this.

 

 

 

 

 

 

 

 

 

[Priyabrata]

Hi,

In this case you could use the perform find to get the record from a list or you can  filter the portal using global field having ID value list.

[bcooney]

Try using ==1

 

Is this field a number field?

 

http://www.filemaker.com/12help/html/find_sort.5.6.html#1050963

[Sir_Duck]

Yes It's a number filed.

 

And I want to change the number to search for anytime with help of a valuelist (from 1 to about 10 000 or more). So when i choose a new number from the value list, ==1doesn't  work.

 

Or am I wrong?

[bcooney]

Um..why would anyone need a value list of numbers? That's the part I don't understand. Also, finding in a number field does not find 1, 10, and 100 if 1 is entered.

[Sir_Duck]

The use of the database is to store data of inventors, so the need to know what's connected to a number is very important. If you own 10 000 objects it's hard to know what you have (That's what we use the value list for!). The find function is to find all data connected to one id number. We have a drop down list with all I'd nr that's in use so delete ones is not shown.

 

Normally we use FM 12 Go on iPad look for a item or Id nr and we only want the find function to show all data connected to one filed, for example id 567. 

 

So the problem is if any other data is inserted in the database like a room nr 5678 it will show the id nr 567 and the room 5678.

 

Example what Find will show:

 

Id nr 567 painting, room 1134- This should be shown

 

Id nr 4567 Chair, room 5678- This shouldn't be shown 

Id nr 30567 table, room 5678-This shouldn't be shown 

Id nr 30567 Sofa, room 5678-This shouldn't be shown

Id nr 3038 painting, room 5678-This shouldn't be shown

[bcooney]

If you are doing a Find in a number field (your ID is a number field in Define Fields), then why would records with that value in another field show? Again, your original post requested a value list of numbers...how does that possibly help a user?

 

Post a demo file, please. Obviously we're overlooking something.

[dansmith65]

Perhaps you are using Quick Find (the box in the top-right corner) instead of entering find mode, enter the number you want to find in the field you want to find it in, then click perform find?