Look up on two fields in a form in SQL

I want to look up a field for display that would need a join on two columns, ie order # and lineitem #. I want to display the product and have the order # and lineitem # entered into the field. I can only reference the product by supplying both order number and item number. Any pointers????? --Kate