Reposted: Calling data from another table (error on my previous thread)

[johannaellamay]

Hi! I have two tables for Employees and Properties of the company. Each property is assigned to a particular employee. Here are the details:

Employees Table
Last Name
First Name
Department
Position
Supervisor
Date Hired
Location

Properties Table
Property number
Item description
Assigned employee (lookup field based on the query below)
Position
Department
Supervisor

Employees Query
Concatenated field for Last Name and First Name
Position
Department
Supervisor

What I want is that when the user selects an employee on the Properties table, the rest of the data (position, department, supervisor) will automatically show. How do I do this?

 

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

 

[Galaxiom]

It looks like you are breaching normalization by storing the Position, Department and Supervisor in both tables.

BTW "Properties" is not a good name for a table or other object since it already is the name of a very important collection attached to almost every object in Access.

 

[johannaellamay]

How about:

http://www.baldyweb.com/Autofill.htm

Hi! Thanks for the link. It was extremely helpful.

 

[johannaellamay]

It looks like you are breaching normalization by storing the Position, Department and Supervisor in both tables.

BTW "Properties" is not a good name for a table or other object since it already is the name of a very important collection attached to almost every object in Access.

Yes I understand. I'll explain what I'm trying to do in my next reply. About "Properties", my table's name is actually "t_Properties"

 

[johannaellamay]

I have the same tables and query above. What I am actually trying to do is I'm creating a company-based form. We call it Property Accountability Form (PAF) where information about a certain property and the staff assigned are placed and they also sign it. The form should contain the following:

Name of assignee (taken from t_Employee or q_Employee or t_Properties, whichever is best, I don't know yet)
Position (taken from t_Employee or q_Employee or t_Properties, whichever is best, I don't know yet)
Department (taken from t_Employee or q_Employee or t_Properties, whichever is best, I don't know yet)
Date Issued
Name of property custodian
Supervisor of assignee (taken from t_Employee or q_Employee or t_Properties, whichever is best, I don't know yet)
Property number of item (taken from t_Properties)
Item description (taken from t_Properties)
Date Acquired (taken from t_Properties)
Remarks

Then the form should be printable. We use the PAF for accountability purposes. What is my best option for this?