I have 1 form which has customer data, and another which has employee data.

Now I have created a third form which stores installation data, which (in addition to other fields) has 2 lookup fields:

1. One for the customer form (as company name - city - state) and 

2. Second for the employee form (as First Name - Last name - Location) 

Now I am trying to import some data into the installation form, but what is happening, its creating new entries in the customer form and the employee form. I want to use the import to match with existing data in the customer and employee form - not add the data.

Regarding the 2 lookup fields, in my data to import I have them so that they look exactly like the lookup field in the form. For example, for the customer form lookup field, in my installation data I have put the entries as company name - city - state, which is how I have defined the lookup field in the installation form.

Any ideas what I am doing wrong? Or how to import the data correctly?

Thanks,

Rajat