Data in table but not in form or query

[jennie999]

Hi - I have created an access database (2003)

• I have 3 tables - person, tester and tests
• the database is designed to create fitness tests - for people in the person table - by testers - in the testers table - and the tests table hold the dates and results of the tests
• I have created a form - using the wizard but am not seeing any data in the form - I imported 600+ records into the person table - from excel
• I also created a query - but cannot see any data (from the person table - in the query
• I created relationships on one to many from the testers to the test data and one to many from the person to the test data

Can you advise me if I have completed the basics so far ok - but why I am not seeing the data (from the person table) in the query or the form

[weekend00]

you do not have the right query

[slave138]

Can you post the query? It might help determine why no records are being returned.

[jennie999]

Hi The sql is

SELECT Personnel.[First Name], Personnel.Surname, Personnel.Station, Personnel.Role, [Tests Data].Test_Date, Testers.[Tester Name]
FROM Testers INNER JOIN (Personnel INNER JOIN [Tests Data] ON Personnel.Person_ID = [Tests Data].Person_ID) ON Testers.Tester_ID = [Tests Data].Tester_ID;

Although I am building not using sql

[weekend00]

You don't get any record return because you don't have match data in other 2 tables.

[jennie999]

Ok - I prob don't have the right joins and primary keys set up

I have let access create a primary key on person id, tester id and test id - and linked the person id and tester id to the test id in relationships window