Converting Field in a Form

[Mattie]

I have a form based on TABLE A which has two sets of Employee IDs Example
TABLE A
EmployeeID MGRS Employee ID nonmanagers
278 379

I have another TABLE Support Personeel that has
Employee ID Name
278 Jane Smith
379 Bob Jones

How can I make the FORM show the personal names Jane Smith and Bob Jones
instead of the employee IDs?

 

[Bob Quintal]

I have a form based on TABLE A which has two sets of Employee IDs
Example TABLE A
EmployeeID MGRS Employee ID nonmanagers
278 379

I have another TABLE Support Personeel that has
Employee ID Name
278 Jane Smith
379 Bob Jones

How can I make the FORM show the personal names Jane Smith and Bob
Jones instead of the employee IDs?

There are several ways. Which one is best depends on what you need
the form to do. (Add/Edit, show only)

For Add/Edit, change the textboxes to comboboxes that lookup the
value of employee name and ID from the table.

For show only, use a query that joins the Manager ID field to one
instance of support Personel and the nonmanagerID to a second
instance of the support Personnel table.

 

[KARL DEWEY]

I would change the other table to this ---
EmployeeID LName FName MGR
278 Smith Jane X
379 Jones Bob _
One table!

 

[Bob Quintal]

I would change the other table to this ---
EmployeeID LName FName MGR
278 Smith Jane X
379 Jones Bob _
One table!

Why? My example use one table, twice, not two tables..the definition of
manager subordinate is contained in the table_A



IF YOU ADD MGR YOU CANNOT SHOW:

Big MGR
Little MGR1 Others
Employee1 Employee2

littleMGR1 is both boss X and -

 

[Mattie]

Bob,
This will be for view only.
So I guess the only way to do this is base the form fields off the query
instead of the table?
Thank you very much

 

[Bob Quintal]

Bob,
This will be for view only.
So I guess the only way to do this is base the form fields off
the query instead of the table?
Thank you very much

That is the easiest way. The combobox option is more work to set up,
slower to load and I think comboboxes look ugly on a read-only form.

You sound apprehensive about using a query. Why?

Q

=?Utf-8?B?S0FSTCBERVdFWQ==?=

Why? My example use one table, twice, not two tables..the
definition of manager subordinate is contained in the table_A



IF YOU ADD MGR YOU CANNOT SHOW:

Big MGR
Little MGR1 Others
Employee1 Employee2

littleMGR1 is both boss X and -

 

[Mattie]

I guess i was trying to turn something easy (now that you explained) into
difficult. Just thought there might be a cool way to bypass the query.
Thanks again.

Bob,
This will be for view only.
So I guess the only way to do this is base the form fields off
the query instead of the table?
Thank you very much

That is the easiest way. The combobox option is more work to set up,
slower to load and I think comboboxes look ugly on a read-only form.

You sound apprehensive about using a query. Why?

Q