Lookup from two fields

[adam19ku]

In the costing database I'm building, we will add inventory items together into a catalog item to calculate the total cost. Right now, when I enter the item code, it looks up the description, weight, and cost. Problem is, some employees who are less familiar with the cryptic item codes will be doing some of this costing also. Is it possible to have either the item code or the description do the lookup? Ideally, I'd like to have the description field be a drop-down list of the items available for it to look up (I have the item code field working this way).

Edited January 11, 2008 by Guest

[Raybaudi]

Hi

put on your layout a copy of the same field that you use to make the lookup, but using a new list coming from the same item code, but showing ONLY the second field ( description )

[adam19ku]

but then I have two instances of the same field in the layout

[Raybaudi]

Is it possible to have either the item code or the description do the lookup?

Didn't you ask for a way to get the lookup from the item code or the description ?

[adam19ku]

yes, I was hoping there was a way for the Description field already in existance to do the same thing as the duplicated Item Code field, so then I didn't have two Item Code fields in the layout.

[David Jondreau]

Try this...

Make a second relation based on Description and use an auto enter calculation for the code (check Do not replace).

related_by_Description::Code