Greetings:
I am trying to create a report that will list various project categories.
I am basing it off of a query that uses three tables (PONo, ProjectNo, Project SubNo).
The design is such that the PO# table has 4 sets of ProjectNo and Project SubNo lists (i.e. Project 1, Project 2, Project 3 and Project4)
I would like for my report to show the actual Project Name (referred to in the number) for each of the projects.
What would be the best way to do that? I hope this isn't tooooo confusing.
I am trying to create a report that will list various project categories.
I am basing it off of a query that uses three tables (PONo, ProjectNo, Project SubNo).
The design is such that the PO# table has 4 sets of ProjectNo and Project SubNo lists (i.e. Project 1, Project 2, Project 3 and Project4)
I would like for my report to show the actual Project Name (referred to in the number) for each of the projects.
What would be the best way to do that? I hope this isn't tooooo confusing.