If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a contracts database
Ok, so I'm starting over from scratch. It seems like the
more I read the more confused I become. Anyway, I need to create this database where we can input data about our contracts (specifically; contract#, contract name, our contact person, their contact person, date recieved, start date, end date, route date, completion, $ amount, contract type, account#, PO#(if needed), and who entered the data), then we need to be able to see which contracts have not yet been completed. That is to say, we need to track our contracts to know which contracts have all the necessary signatures, and which ones are still out in the field needing to be signed. So far, I've created two tables. One ContractType, has one field with the same heading, and twelve different "records", one for each type of contract. The other table, ContractInfo, has a field for each of those catagories I've listed above. We've created a field labeled "Completion" which I've made into a Yes/No entry. I did this thinking this is what we would use to check to see if the contract has all the required signatures. Does this make sense? Basically after this point, I'm stuck. What else needs to be done, so we can enter in the data, and search the data to see which contracts are still in the field? I know that I probably need to create relationships between the tables, but what am I relating, and why? It's just not making much sense to me. Thanks again for all your replys and comments. Hopefully I'll be able to finish this project sometime soon. -Justin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating a contracts database | justin | New Users | 1 | February 21st, 2005 08:57 PM |
Creating a database file | Baylynx | Contacts | 1 | December 14th, 2004 07:29 PM |
Converting 97 database to 2003 database and implications | John | Database Design | 1 | November 22nd, 2004 05:23 AM |
Creating an access database | T | General Discussion | 8 | July 30th, 2004 09:21 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |