I am positive that the answer I'm looking for is in some sort of tutorial somewhere but I don't know what to search for.
I would like to run a report (I think) that gives me all the items for a specific cost center.
I have a tblCostCenter which has the 10 or so cost centers listed. It's in a one to many relationship with the CostCenter field in tblCorporateFixedAssets.
I want to be able to have a pretty report where the person chooses the cost center from tblCostCenter and then it returns all the assets assigned to that cost center.
I know I can run a qry on each and every cost center and thus a report from that, but I dont' want to do that, I want something (maybe it isn't a report. . . ) to open, ask you to choose which cost center and then voila, all the assets.
So if this isn't a report, what is it? And what should I search for to find my answer. I've tried data from different tables and things like that but nothing I've found involves a drop down choice from a different table.
Thank you in advance.