Project management database

[Alfi83]

Hi

I'm trying to create a database for project management and have a question about revision controls.

One project shall have one engineering review before our small company can start production. So i am guessing I should use a one to one relationship? but, the engineering review might be changes as new information comes inn and it is important that we can keep track of these changes. Does anyone have a good ide or an example to how i can fix this? Project number looks like PO XXXXXX.




Best regards,

A

[orange]

Do you have aa good, clear description of WHAT you are trying to do? Why is project number format an issue at this point?

I recommend you work through this tutorial to understand your required tables and relationships.
In addition, you should find and follow a naming convention that does not allow embedded spaces in field and object names.
Use only alpha numerics - no special characters !@#$%^&* etc. - in your field and object names.

Good luck.

[ItsMe]

Perhaps an off the shelf solution such as Microsoft Office Project will best suit your needs.
http://office.microsoft.com/en-us/project/