Hey guys, here&#039s the situation.<BR>I have 2 tables in an Access Database.<BR>I am using Microsoft.Jet.OLEDB.4.0<BR><BR>In table 1 (Departments) I have Department and DepartmentID<BR>In table 2 (Positions) I have PosID, DepartmentID, and Post<BR><BR>The DepartmentID in both are linked by a one-to-many relationship.<BR><BR>Now I want to show the Department only if the Post = yes.<BR>Problem is in the Positions table DepartmentID can be shown more than once and I can&#039t figure out how to search for the yes, and once found, have it stop and go to the next DepartmentID.<BR><BR>Any ideas?<BR><BR>(PS - Hope this made sense)<BR>