B
Build or Die
I have an unbound form with a continuous subform on it. The subform displays
all current projects and basic information for searching and a few buttons to
other forms. I would like to include the client (companyID) on this subform
but multiple records for the same project number apear when there are
multiple client listings for one project.
I'm thinking a list box could solve the problem of listing one or more
clients per project, but I'm lost on getting the listbox to link by project #
(like a parent-child link for subforms). Would a GROUP BY work? or perhaps
an unbound Listbox that populates ON Current & On requery?
Any help?
Thanks
Current Query:
SELECT DISTINCT tblProject.ProjectYear, tblProject.ProjectID,
tblProject.ProjectName, tblProject.ProjectCity, tblProject.ProjectState,
[ProjectCity] & "," & " " & [ProjectState] AS CityState FROM tblProject INNER
JOIN (tblCompanyOrVillage INNER JOIN tblcontactdetails ON
tblCompanyOrVillage.CompanyOrVillageID=tblcontactdetails.CompanyID) ON
tblProject.ProjectID=tblcontactdetails.ProjectID ORDER BY
tblProject.ProjectYear DESC , tblProject.ProjectID DESC;
all current projects and basic information for searching and a few buttons to
other forms. I would like to include the client (companyID) on this subform
but multiple records for the same project number apear when there are
multiple client listings for one project.
I'm thinking a list box could solve the problem of listing one or more
clients per project, but I'm lost on getting the listbox to link by project #
(like a parent-child link for subforms). Would a GROUP BY work? or perhaps
an unbound Listbox that populates ON Current & On requery?
Any help?
Thanks
Current Query:
SELECT DISTINCT tblProject.ProjectYear, tblProject.ProjectID,
tblProject.ProjectName, tblProject.ProjectCity, tblProject.ProjectState,
[ProjectCity] & "," & " " & [ProjectState] AS CityState FROM tblProject INNER
JOIN (tblCompanyOrVillage INNER JOIN tblcontactdetails ON
tblCompanyOrVillage.CompanyOrVillageID=tblcontactdetails.CompanyID) ON
tblProject.ProjectID=tblcontactdetails.ProjectID ORDER BY
tblProject.ProjectYear DESC , tblProject.ProjectID DESC;