ComboBox Continuous Records Report 1

[Elvis72]

I have the following Tables:

TblConstructionServices
TblResumes

That have information that I need to bring into a report, which I have done.

BUT I also have a TblStaffingRequirements that has the list of Titles needed for a project.

AND TblStaffingRequirementsList that links it with TblConstructionServices.

What I can't wrap my head around is how to show the positions for each project?

I'm sure none of what I just said makes much sense, please ask any questions!~

 

[lameid]

Sounds like you want the report you have and a subreport whose recordsource joins TblStaffingRequirements and TblStaffingRequirementsList.

When you drag a report from the database window and drop it in a report you get a subreport. If you get the properties of that control you can specify "Link Master Fields" and "Link Child Fields". This is basically an outer join between the two reports. The field list for these properties must contain the same number of elements and are separated by semicolons. If you put your cursor in the property box, you get the build button to the right with three dots (...). Clicking that gives you a wizard to match up the fields or you can specify them manually.

You could also try putting everything in one report and hiding duplicate fields and sorting appropirately but this kills the ability to get expected results from any aggregate functions.

 

[Elvis72]

All I can say is thank you!~ And you ROCK!~

So needed that short paragraph to put it into perspective!~

Thanks sooooo very much!~