Information in a table does not appear on the form

  • Thread starter Thread starter Frustrated Chris
  • Start date Start date
F

Frustrated Chris

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.
 
Chris,
check that your form has its Data Entry property set to No.
( property dialog, data tab)


Jeanette Cunningham
 
Back
Top