Best way to lay out the database

[antr]

Hi all,
I have been playing around with Access to try and do a project tracker for my team at work.
The manager will load a project and input information and then the analyst will update this (seeing different options)

I want to be able to have many updates (seperate records) for each project.

The problem I have found though is the way I set up this database (a load table and an update table) is that when a report is run, it keeps showing up the project name rather than just one row.

Whats the best way to set it up. I need to be able to open a report for each project to be able to read every update.

Thanks

 

[maosc]

Hi antr,
You have two table one for Project Details and one for project Updates details. Also i suppose you are updating the project id in updates table. You just create a query called "query1" by both tables Project Details and Updates table joining with project id and do the following on report in design view:.
1. set recordsource "query1" in data tab of report property.
2. right click on report and select "Group and Sorting". A window will appear botton side of report.
3. click "Group" and use field name project id. A project id header section will appear on report. add all information of project details in header section.
3. and add all information in detail section of updates information.


If any query just upload your db structure.