Missing data-not sure if it is a relationship issue or query issue

[Guest]

Okay, I have Table, Query that uses the table to pull the data and a form of
which uses the query.

Query pulls from two tables, emplye roster and test given.
emply name from roster and name from test given. Qry working fine.

The table has empl numb, empl name, and other data, the query is working
exactly as it should. It has all fields filled in, but when it feeds back
to the table the name field is empty. I have checked to see if it allow
duplicates and it does, so is not that issue. I have also looked at the
relationship issue and to no avail no results still. Please help!

 

[John Vinson]

Okay, I have Table, Query that uses the table to pull the data and a form of
which uses the query.

Query pulls from two tables, emplye roster and test given.
emply name from roster and name from test given. Qry working fine.

The table has empl numb, empl name, and other data, the query is working
exactly as it should. It has all fields filled in, but when it feeds back
to the table the name field is empty. I have checked to see if it allow
duplicates and it does, so is not that issue. I have also looked at the
relationship issue and to no avail no results still. Please help!

Please open the Query in SQL view and post the SQL text here.

If you're pulling up the name of an existing employee, there should be
nothing making the Name field be empty. Is the existing name being
erased? or do you have two Name fields (you shouldn't)?

John W. Vinson[MVP]

 

[Guest]

Okay, I have Table, Query that uses the table to pull the data and a form of
which uses the query.

Query pulls from two tables, emplye roster and test given.
emply name from roster and name from test given. Qry working fine.

The table has empl numb, empl name, and other data, the query is working
exactly as it should. It has all fields filled in, but when it feeds back
to the table the name field is empty. I have checked to see if it allow
duplicates and it does, so is not that issue. I have also looked at the
relationship issue and to no avail no results still. Please help!

Please open the Query in SQL view and post the SQL text here.

If you're pulling up the name of an existing employee, there should be
nothing making the Name field be empty. Is the existing name being
erased? or do you have two Name fields (you shouldn't)?

John W. Vinson[MVP]
SELECT [Prex Given].SSN, [RCT Info].Name, [Prex Given].[Prex #], [Prex Given].[Prex level], [Prex Given].[Prex type], [Prex Given].Date, [Prex Given].Score, [Prex Given].[Record #], [Prex Given].[Job title], [Prex Given].[Pass/Fail], [Prex Given].[Supervisor Obs], [Prex Given].[Supervisor Name], [Prex Given].[Supervisor Obs Sat], [Prex Given].PERNR

FROM [Prex Given] INNER JOIN [RCT Info] ON [Prex Given].SSN = [RCT Info].SSN;