not showing all records

[oilman]

I am using FM 4.0v1 and have made a value list from another db to display in my main db. The value db has fields that list the type and grade of material. Since is it hard to determine what type of material is being chose by just looking at the grade I have check the box that says show information for other fields. But only the first matches showup in the value list in the main db.

Example:

Grade Type

SA234 Pipe

SA516 Plate

SA106 Pipe

Value list will only show SA234 and SA516 (along with the type) put not SA106

could someone suggest what I am doing wrong?

[IdealData]

You must be sorting by the second field - as a result FMP only displays the first match for each indexed item.

If you sort by first field you'll get a better result, but your "pipes" and "plates" will be all over the place, however at least you can select every valid entry. I assume the "Grade" is the unique factor in your DB and the "Type" is a method of grouping.

[oilman]

Mark

thanks, but i am sorting by the first field. there are 22 files in the db and only 5 diiferent type (plate, Pipe, Forging, fitting, and tubes). The value list shows only the first five regradless of how the sort is done. Any ideas of what i am doing wrong. The type is just to help the operator to pick the correct grade.

thanks

[The Bridge]

Forgive me if I misunderstand, but you may want to create a relationship between the Type field in the main database and the Type field in the grades database (I assume this is how the files are structured). Base the grades valuelist on that relationship. Then, when the user selects a Type in the main database, the valuelist will display all grades that correspond to that type.

I hope this helps!

[oilman]

Bridge

thanks, but there is no field in the main db call type. type is just in the grade db so the operator can decide what material to chose.

Example

Grade type

SB423-N06600 pipe

SB424-N06600 plate

This lets the operator who is completing the form to check if the field person has given the correct grade to them. The operator knows if the test was done on pipe or plate. This helps since the grade numbers can be similar.

thanks

[The Bridge]

Sorry, Oilman -- I realized after looking at your original post that I don't think my solution would work, anyway -- I believe that related valuelists didn't appear until v.5.0.

I'm not entirely clear on how your system works, and it is way out of my field, but you may want to just create a portal showing records where Grade in the main database matches the Grade in the grades database. I'm assuming that a grade can have more than one type. If not, then you can just put the related field directly on the layout. Whenever an operator selects a Grade, the related Type will be filled in automatically. Just don't allow entry into the related Type field.

I hope this is clear. More importantly, I hope this helps more than my last suggestion.

[oilman]

thanks peter

[Vaughan]

First update to FMP 4.0v3 -- your problem may be caused by a bug that has already been fixed. Get the update from http://www.filemaker.com

[oilman]

Thanks Vaughan

will do

[oilman]

Vaughan

did the double download 4.0v2 and 4.0v3 and this did not help. value list still displays only the first five matches. any ideas of where i have going wrong.