I have been over thinking this problem and now I am lost in the woods. Any information or advice would be greatly appreciated. I don't know if this should all be in one table or broken up in to two or more.

I have Projects and Assets. One of my problems is that each Project dictates the name of the asset.

Examples of Project names:

001_Veh_Cycle

002_Veh_Plane

001_Env_Mountain

002_Env_Rivers

The asset names are

001_Veh_Cycle_Handlebars

001_Veh_Plane_Wings

What I need to do is enter data on each individual asset. Design date, artist name, Approval Status, etc.

But each Project that is made up of multiple assets has it's own data. Completion date of Project. Delivery Date.

Then I need to create a report that will pull up the Project name (001_Veh_Cycle) and then report all the smaller assets with their individual data.

I have created two tables. Assets & Projects with the ProjectID as a foreign key in Assets. Is this correct?

When creating the report, How do I make sure only the sub set of assets that belong to the project appear and not everything labeled 001_Veh?

I hope this makes sense. I am floundering here.

Thank you for your help.

Sounds like you have made a nice start. So your ERD is currently:

Project --< Asset

each project can have one or more assets. How you name them is up to you.

If you are looking at a Project [ex: 001_Veh_Cycle, you will want to GoToRelatedRecord where projectID::projectID. You will now be in the Asset table with the child records. This is where you will build your report.

The report will be a subsummary report in order to format the report nicely. You will need a minimum of two parts:

subsummary [sort by ProjectID in Project] Field: Project Name

body: field: Asset Name

Good start and good luck!

Thank you for the help!!