Good morning everyone.
I am quite new at access and have been reading a lot and trying to set up what I would consider to be a fairly reasonable database to give you some background.
The database is to collect information about projects. This information would include no less than the following:
Project name
financial information: estimates, funding, negotiating information
Key dates
Individuals working on project
The customer information
Work Orders
Key project documents
Project notes
Many of these topics are broken down into the respective data required for each project and the only information what would apply to the many side of the database if the user and the individuals working the project. Every other piece of information is only specific to that project, can, and will never be used again. Right now all if this information is contained in a spreadsheet; however, it is becoming massive and too much to maintain.
I have a form set up with a tabbed control on a main form. The main form contains the project title, location, work order and a couple key dates and links. The tabbed form contains other relevant information to the project and their related tables. When I update the main form and fill out all of the tabbed sections the main form will go to a new record. The tabbed forms will not and I cannot add new records. Also, when I go back to record 1 on the main form it will not display my information, though, I verified it is located in the tables.
Right now my relationships are set up on one to many based on the work order cell contained in each table. With the primary key set to auto number in every table with the exception of the main table where the work order is the primary key. I was going the one to one approach; however, I have read over and over that this is not common at all and thought I may be barking up the wrong tree.
I guess my questions are.. am I approacing the table design correctly?
What would be causing my form problems?
and in reality is this a flat database?
Like I said I am new and learning.. I might not be asking the right questions and thus not finding the answers I need through net searches. Not to mention I am having a hard time getting away from the "spreadsheet" approach to life!
Thanks in advance!