Hi
I am trying to filter records based upon the Dept.
I have the following tables.
Tbl_Start_Leaver
PtSubDept (e.g. PT-271
EffectiveDate
ChangeType
Cdsid
Surname
Forename
Title
Grade
SAP Position No
Position Type
Comments
Tbl_Pt_Dept
PtSubDept PT-271
PtDept PT-27
SeniorMgrType PT-2
I have a form that has a combo box to try and filter the records.
The problem is that the drop down for the combo box appears to work but I can see that something is not right in the way that I am setting this up.
in the row Source of the combobox I have following SQL :
SELECT Tbl_Start_Leaver.ID, Tbl_Pt_Dept.ID, Tbl_Start_Leaver.PtSubDept, Tbl_Pt_Dept.PtSubDept
FROM Tbl_Start_Leaver
INNER JOIN Tbl_Pt_Dept ON Tbl_Start_Leaver.ID = Tbl_Pt_Dept.ID;
This clear does not appear to be the correct way.
I need to be able to have PT-27 and I would only only have two records in my display i.e.
PT-27 and PT-271 likewise if I chose PT-60 I would get PT-60 and PT-601.
Hope I have explained correctly.
Thanks in advance for any help.