Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use Joins

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have an employee review form which has the basic info for the employee (name, date of hire, etc) an then the review. What I want is to create a database with only employee information. Then, when I'm doing a review, I can simply pick the employee name and the rest of the fields (date of hire, etc) will be filled in automatically. What is the best strategy for doing this.

I am fairly proficient using approach, but I have never used joins (not smart, I know). Any basic tips would also be appreciated for using joins.

Thanks,
RB
 
1) First you need to define your "review" database and include in it a field that would identify the employee record it matches up with.

2) Next add a unique ID field to your "employee" database if you do not already have one.

3) While in the "employee" database, click Create - Join and then the Open button. Select the "review" database. Then select each ID field and the Join button. That's all you need to do there.

4) Create a form view based on "review" and put the ID field from "review" on it. Add fields from "employee" to that view to display the matching employee information.

5) When you enter a valid employee ID into the review's ID field, the join is completed and the employee fields fill in.

That's about all there is to it.

Sue Sloan
XpertSS.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top