value lists and lookups

[richardb]

I have two fields in my database, Item Number and Operation descritption which are listed in another related file.

What I want to a achieve is, if you click on item number, a value list of all the item numbers comes up and once one is selected, the corresponding operation description is entered AND (and this is the part I can't do) when the operation desciption is clicked on, the list of operations pops up and the item number is automatically entered!! I can do one or the other but not both. The idea being that the user can look-up either the item number OR the description and the other corresponding variable is automatically entered. Any help much apprectiated.

------------------

[Vaughan]

If you can write a script to do some or all of this... put a transparent button over the field so the script runs when people click on the field.

[Kate Needham]

Vaughn, can you give me a little more detail. I'm trying to achieve the same thing (have one field call up information in another).

[grant]

Just a suggestion.

Why not use a value list that picks up the Item Number AND the Operation

e.g. 23 Plastic Frog

This way the user can see what the operation is and choose it.

I do this on the Item number field, go to Field Format and make a Value list based on the other file. It works separately to the relationship.

Hope that makes sense

[Wimek]

I also ran into that problem. I solved it the same way: showing both the number and the discription. It works fine, but I realy hope that Filemaker provides us a way to show only the discription, while choosing the number in the next version of FM !