Access Relationship Problem

[AlexB]

I am creating a Project Management database for the company that I work with, and I am having problems trying to run a query off a few tables. I think it is to do with the relationships that I am using to link the tables together.

The idea is to bring together a couple of fields from each of the tables to be displayed in a sub form on a form that brings together details from a whole variety of tables.


I need to bring together :

- EmployeeName from the Employee Details table
- SkillDescription from the SkillDetails table
- Estimate%Required from the Resource table
- Description from the Resource table

As soon as I bring up the SkillDetails table on the relationship window the query cant do anything - when I execute the Query it doesn't even return blank fields - just the title and nothing else.

Any suggestions on what to do to fix it??

 

[neileg]

In your query only, delete one of the links to the SkillDetails table. This won't change the relationships in the database, just in the query.

 

[Pat Hartman]

To solve your immediate problem,
1. Remove the link from the employee table to the skill table.
2. Add the skill table to the QBE grid a second time. Notice that Access suffixes the second instance with "_1" so that it can be distinguished from the first instance.
3. Draw a join line from the employee table to the new instance of the skill table.
4. You'll need to rename the skill description field in the query to MainSkillDescription to distinguish it from the other skill description.

You should not have Skills in the employee table since an employee may have multiple skills.