Hi peeps,

I'm creating a simple db to stor project details. Each project has a unique name, and is part of a programme. Each programme name (ie SIG023) can have multiple projects. these projects recieve numerous support plans, guides and tto plans. I also want to store comments on each project.

Does my relationships and table structures look ok? am i starting in the right lines?

Has anyone come accross a similar db?

Appreciate any advice.

Mike

Short answer... Because all fields in each of the three tables are, essentially, the same I would combine the three Plan/GuideInfo tables into one table with a FK DocumentTypeID field to indicate whether each record is for a TTOPlan, or a SupportPlan, or a SupportGuide. This field would store the numeric key value from an associated table DocumentTypes that stores DocumentTypeID (auto,pk) and DocumentTypeName (Text).

Use criteria queries to show you the records for each type, or all types, of documents that you need to see.

Ahhh, that sounds so obvious! Thanks for the reply. I'll implement that into my table structure. Thanks :D

I'll probably be back with more questions as i build on this!

Mike

Happy to help...good luck with your project :)