Design Question

[bdriscoll]

I have a project database with a large part in a flat table. The projects table has information on planning, equipment, design and contract infromation. Other tables are employees, invoices, funding etc. Most projects don't have go thru all phases; therefore don't have data in all tables (planning, equipment, design and contract). Should I split this into four tables? If so, how is a record inititated in one of these tables? A yes/no box?

TIA,
bdriscoll

[RuralGuy]

Have you read any Normalization information yet? Google can find tons and it is best to get the design set up correctly right from the start.

[marianne]

i would recomment RuralGuy's suggestion.

[bdriscoll]

Thanks, will do!