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
|
|||
|
|||
Add New Field to DB
I have a DB that someone who once worked here created. The DB is not set up
properly and I don't have the time to create another one and learn how to import all this data. Therefore, I have to work with what I have. This DB is used to track our company traning procedures for each employee. There are no primary keys set up and the employee table has the first and last names combined in one field - to give you an idea. Below are the table structures: Employee Table: EmployeeName EmployeeNumber DateOfHire TerminationDate Procedures Table: ProcedureNumber ProcedureName ProcedureType Training Grid Table: ProcedureNumber TrainingType EmployeeName DocumentationDate Training Type Table: Training Type We have changed our Procedure Numbers and they are now called NT Numbers. We are in the middle of changing over all the procedure numbers to the new numbers. In the mean time, I have to track this info in our database. As far as I know, a query should have been created to be used for data entry and the previous employee is using the "Training Grid" table for that purpose. How should this DB be changed so I can add a new field for "NT Number" and have each NT Number correspond in there respective record with the old procedure number? I hope I am explaining this so it is understood. Please let me know if I'm not - I really need to start entering the new numbers. ANY help would be greatly appreciated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help to merge Image (Doug Robins?) | JohnB | Mailmerge | 21 | June 23rd, 2005 05:28 PM |
DCount compare table.textfield to form.text field question | RNUSZ@OKDPS | Using Forms | 1 | March 11th, 2005 02:05 AM |
New Record Update | Michelle | Using Forms | 5 | October 28th, 2004 07:59 AM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |