Queries and Relationships

Resolved · Urgent Priority · Version 2007

Mon 31 Mar 2014, 12:35 Delegate Jackie said...

Jackie has attended:
Access Intermediate course
Access Advanced course
Advanced Excel Dashboards course
Excel PowerPivot course

Queries and Relationships

We have three tables which have relationship links. Table 1is linked from the primary autonumber key to a foreign key in the Table 2. Table 2 is linked by a separate primary key to a foreign key in Table 3
When we try to run a select query to obtain data from all three tables we get no results. What are we doing wrong?

Mon 31 Mar 2014, 14:14 Trainer Jens said...

RE: Queries and Relationships

Hi Jackie,

Thank you for the forum question.

When we are working with databases there can be a lot of reasons why a query isn't returning any records. It is not possible to say what's wrong without having the database in front of you.

If you forward me the datebase I will have look at it.

You can forward the file to info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Mon 31 Mar 2014, 19:06 Trainer Jens said...

RE: Queries and Relationships

Hi Jackie,

Thank you for the database.

I have examined the queries and if you have a look at the Query Visit by Consultant there is no related records.

If you double click the joined line between the tables in the query and select 3: "Include all records from Visit details....." and run the query you can see there is no related records. You can in the field ProjectIDFK relate the Visit Details to the Project details.

I hope this will clarify the issue.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Wed 2 Apr 2014, 10:48 Delegate Jackie said...

RE: Queries and Relationships

Hi Jens

Thanks I realise now we had not completed the foreign key column with the respective id number form the linked data table. I have now done this and it works! :) Just a simple thing but was really frustrating. Thanks very much.
Jackie & Penny

Wed 2 Apr 2014, 11:54 Trainer Jens said...

RE: Queries and Relationships

Hi Jackie,

I am happy to hear that you solved the problem.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu

Wed 9 Apr 2014: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips