Chain of Lookup Fields

Hi everyone,

I am trying to make a chain of lookup fields across multiple forms.

In other words:
Form 1 = Company Names
      Field = Company

Form 2 = New Leads
      Lookup Field to Company in Form 1

Form 3 = Work in Progress
      Lookup Field to Company in Form 2

The idea is that we collect as many company names as possible and make a database in Form 1 = Company Names.

As the names are qualified they will get entered into the New Leads (Form 2), the company name being selected by a Lookup field pointing at Form 1 -> Company Names.

When the deal comes in, the names will then get entered into Work in Progress (form 3) via another Lookup pointing to Form 2 -> Company.

Essentially when a new job comes in, I only want to be able to select a name that has been entered in the second form database, otherwise I will have to sort through hundreds of names in the first form.

When I try to point a new Lookup in a third form to a Lookup in the second Form, there is no option to select it. All the other fields are there, but the Lookup is not.

Can Lookups be connected in a chain to each other across multiple forms?