Multipal Find

[Dani Rubenstein]

Hello to all.

I what to create a invoive  layout.

when the user has to input a item there will be 3 options to find it.

1.  Barcoce.
2. Item Name.
3. unige serial.

and after they input one off the above options it will input from a look up the other  2 options and value and the price.

what is the way to do it? 

Thanks Dani

[Jeff M]

You're better off posting this in the relationships area as this is likely what you're looking for. I can't be for sure, however, because you've left out some info needed to answer your question. Is there more than a single table, like perhaps a customer or products table?