Hi All,
I have created 3 tables;
tblProjectDirectorates (Fields = ID, Directorate)
tblSubDirectorates (Fields = ID, DirectorateID, Sub-Directorates)
tblProjects (Fields = ID, Project Number, Project Title, Directorate,
Sub-Directorate)
The objective is to use Lookup from 'Data Type' in the tblProjects to
limit the selection of Sub-Directorates based on the previously
selected 'Directorate'. At this stage I do not want to use a form -
just directly update the table.
I have set the Row Source (tblProjects, field=Sub-Directorates) to;
SELECT tblSubDirectorate.ID, tblSubDirectorate.[Sub-Directorate],
tblSubDirectorate.DirectorateID FROM tblSubDirectorate WHERE
tblSubDirectorate.DirectorateID=[Directorate];
However, no records are selected for the table field 'Sub-
Directorate'.
Any advice would be greatly appreciated.
Thanks
Kiers
|
