J
Jennifer
I am having quite a bit of difficulty with this.
1. I have several tables set up. I have a table with managers info based
on an ID. It has address, hire date, etc.
2. Another table with Districts and info that stays with the District even
when a manager changes.
3. A table with Manager ID linked to the District ID and start/end dates and
reasons.
4. A table with Divisions.
5. And another with the Area - MW, SE etc.
And I have a form where the managers info can be edited and we can also add
managers. The form is based on table 1 and there is a subform when we
add/terminate managers.
I want my form to show information from the Division table and District
table so we can easily identify who the record is for. Division and District
is not in the main table as it continually changes per manager.
I tried to base the form off of a query but can't get it to update. I put
in relationships (one-to-many) in the tables. How can I get a text field in
my form to display this other information?
Thanks!
1. I have several tables set up. I have a table with managers info based
on an ID. It has address, hire date, etc.
2. Another table with Districts and info that stays with the District even
when a manager changes.
3. A table with Manager ID linked to the District ID and start/end dates and
reasons.
4. A table with Divisions.
5. And another with the Area - MW, SE etc.
And I have a form where the managers info can be edited and we can also add
managers. The form is based on table 1 and there is a subform when we
add/terminate managers.
I want my form to show information from the Division table and District
table so we can easily identify who the record is for. Division and District
is not in the main table as it continually changes per manager.
I tried to base the form off of a query but can't get it to update. I put
in relationships (one-to-many) in the tables. How can I get a text field in
my form to display this other information?
Thanks!