Display information from other tables

[Jennifer]

I am having quite a bit of difficulty with this.

I have several tables set up and have assigned one-to-many relationships
between them.

1. A table with manager's information including address, shipping, hire
date, birthday, etc.

2. A table with district information that always stays with the district
even when a manager changes.

3. A table with the District ID and Manager ID when a manager is
hired/terminated. They also switch districts often.

4. A table with Division names and ID's

5. A table with Areas - SE, SE etc.

I have a form set up based on the first table. I can't get it to run off of
a query linking all 5 tables and edit/add records.

I want to "display" the Division and District information for the record on
the top of the form so it is easy to see where the manager belongs.

How can I set a text field or some other field to display that inforamtion.

Thanks!

 

[Mr. B]

Create a query with all of the fields that you want (from all of the tables)
and then use that query as the record source for your form. If you need the
data from one form to be displayed on the form but then want information from
the other tables displayed relative to the first table, then you will need to
take a look at using sutforms.

You can use a form to display data from a single table or if you want to
display data from multiple tables on the same form you would need a query as
the record source for the form.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm