I am trying to conduct a lookup but I am somewhat confused about how it actually works because of the error message that I am getting. Let me explain. I have two databases, Item Master and Invoice. I am trying to conduct a lookup on Item# which is a unique field. When I type in the Item# in the Item# field in the invoice file I want it to look up the Item# and it display the Item Description and Price Ea from the Item Master.

Item Master Fields:

Item#

Item Description

Cost

Price

Invoice Fields:

Item#

Item Description

Price Ea.

My relationships between the two files are as follows.

Item#::Item#

Item Descr::Item Descr

Price::Price

I believe that when I conduct a lookup on the Item#, only the Item# will be copied from the Item Master? Is that correct? If so, do I need to have more than one lookup? How do I define the Item# lookup as the trigger for the other two lookups?

The problem is that when I try to define the lookup value and I have my relationship Item#::Item# and then select that field to

In your invoice file. Define the field

Item Description= Lookup Your relationship for Item#::Item#, Item Description. I know this doesn't look good but what it says is in the field Item Description look in the master file for the Item # and return the value in the Item Description field of with that item #. Do this for all fields in your invoice layout then when entering a new Item # the other fields will fill automatically.

Thanks Bob! I actually thought about that on my way to work this morning. I don't want to return the field that I just entered, but rather the fields that have the information related to the field. I was confusing myself.