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

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?