I have a cbo query for the row source that selects once of each instance of ProjectID in the table tbRFIs:

SELECT DISTINCT tbRFIs.ProjectID FROM tbRFIs

I would like it to select once of each instance of the ProjectNo in the cbo. The relationship of ProjectID to ProjectNo is in another table tbProjects.

Is there a way to do this?

David

I have a cbo query for the row source that selects once of each instance of ProjectID in the table tbRFIs:

SELECT DISTINCT tbRFIs.ProjectID FROM tbRFIs

I would like it to select once of each instance of the ProjectNo in the cbo. The relationship of ProjectID to ProjectNo is in another table tbProjects.

Is there a way to do this?

David
Maybe you just need an enhanced query. I'll assume the other table is called ProjNumbers.

SELECT ProjectNO FROM ProjNumbers
INNER JOIN
(SELECT DISTINCT tbRFIs.ProjectID FROM tbRFIs)
AS ProjIDS
ON ProjNumbers.ProjectID = ProjIDs.ProjectID

jal,

Thanks for that...I have just read up all about join and it has solved my problem.

Cheers