Apologies for the title, its fairly indescript.
Scenario
3 Tables and an SQL query.
Table 1 (Raw Data)
Field 1 - identifier key
Field 2 - Status (Data type = Text/Combo Box (Row Source = SELECT [CI - Status Values].Status FROM [CI - Status Values])
Field 3 - name
..and so on...
Table 2 (CI - Status Values)
Field 1 - Status (Data type = Text)
Table 3 (CI-SV Completed Values)
Field 1 - Completed Value (Data type = Text)
Objective:
Create an sql query to select all fields from [Raw Data] based on the values held in [CI-SV Coompleted Values].[Completed Value].
I know this is wrong, but my brain has turned to mush and can't for the life of me think where I am going wrong, any help would be appreciated:
SELECT [Raw data].*
FROM [Raw data]
WHERE ([Raw Data].[Status] = [CI-SV Completed Values].[Completed Value]
ORDER BY [Raw Data].[Name];
Many thanks in advance.