The database that I am designing is to track documents done in a Word
Processing Center.  There are 10 tables in the design.  I created a Form from
the Main table.  There is an Attorneys Table where the Attorneys ID is the
primary key.   Each record in the Attorneys table have the following fields:  
AttorneysId, FirstName, LastName, Floor, Department, Extension, Office, and
other personal information.

I want the following fields from the Attorneys Table to appear in the Main
Form when I enter the AttorneysID:

  FirstName
  LastName
  Extension
  Department
  Floor

In other words, the user will type:

   MP008009 (attorney id) and the above-mentioned fields should be
automatically filled in.

I wrote a Query that extracts the data but cannot get it to show up on the
form.  I think my relationships are incorrect.

Can anyone help me with this.