Two way lookup?

[muzz]

I can't see the wood for the trees on this one so this may be a stupid question.

 

I want to have the option of entering an item by either its ItemCode or ItemName.  The code is a 12 digit number scanned in, with the ItemName then auto-entered by a lookup. However if for some reason there is a problem I'd like to be able to select the item from a drop down of names (rather than manually entering the long serial number) and have that populate the ItemCode field.

 

There may be a better way than lookups but is it possible to have the function I have outlined? 

 

Just to be difficult, for the moment I need to be able to make it function on FMP 8.5.

 

Thanks.

[mr_vodka]

A better option probably would be to have a pop up window where they can search the name, then when they select the record, it sets the ItemCode into the field and closes the window.

[bcooney]

Take a look at this demo. http://fmforums.com/forum/topic/73737-value-list-based-on-another-field/?p=349257

[muzz]

Thanks for your input guys.  I had a quick look at the file bcooney but it said it required FM10 and as I am restricted to 8.5 I didn't explore it further.  I think I'll try to implement your suggestion mr_vodka.

 

Thanks again.