Paradoxically, Access accepts a table name as a query alias.
SQL def for "Q50A_BilletsToWorkingGroups":
Code:
SELECT T11_WorkingGroups.WorkingGroupIDpk, T11_WorkingGroups.WorkingGroup, T10_JunctionTable_BWG.WorkingGroupIDfk FROM T11_WorkingGroups
LEFT JOIN (SELECT T10_JunctionTable_BWG.[BilletIDfk], T10_JunctionTable_BWG.[WorkingGroupIDfk] FROM T10_JunctionTable_BWG
WHERE T10_JunctionTable_BWG.BilletIDfk=Forms![F50_BilletsToWorkingGroups]!BilletIDfk)
AS T10_JunctionTable_BWG
ON T11_WorkingGroups.WorkingGroupIDpk = T10_JunctionTable_BWG.WorkingGroupIDfk
WHERE (((T10_JunctionTable_BWG.WorkingGroupIDfk) Is Null));
SQL def for "Q50C_BilletsToWorkingGroups":
Code:
SELECT T01_Billets.BilletIDpk, T01_Billets.RA_BIN AS RA_BIN_NUMBER, T01_Billets.RA_Billet_Title, T10_JunctionTable_BWG.BilletIDfk
FROM T01_Billets LEFT JOIN (SELECT T10_JunctionTable_BWG.[BilletIDfk], [T10_JunctionTable_BWG].[WorkingGroupIDfk] FROM T10_JunctionTable_BWG
WHERE T10_JunctionTable_BWG.WorkingGroupIDfk=Forms![F50_BilletsToWorkingGroups]!WorkingGroupIDpk)
AS T10_JunctionTable_BWG
ON T01_Billets.BilletIDpk = T10_JunctionTable_BWG.BilletIDfk
WHERE
(((T01_Billets.RA_BIN) Like "*" & [Forms]![F50_BilletsToWorkingGroups]![Search2] & "*")
AND ((T10_JunctionTable_BWG.BilletIDfk) Is Null))
OR (((T01_Billets.RA_Billet_Title) Like "*" & [Forms]![F50_BilletsToWorkingGroups]![Search2] & "*")
AND ((T10_JunctionTable_BWG.BilletIDfk) Is Null));
In my system, both of them works well.