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 database
I'm trying to decide on the best way to design a database that will be tha
majority of yes / no values for instance i have a multiple jobs for one piece of machinery and under the job there are multiple duties that could be done and a rating for each dutie . There are 14+ items that have this format Any suggestions or help is appericated |
#2
|
|||
|
|||
creating a database
Use five tables -
- Equipment EQID - autonumber - primary key (PK) Equip Code - text Description - text Remarks - memo - Job JOBID - autonumber - primary key (PK) EQID - number - (FK) JOB - number - (FK) DutyRec - number - (FK) Start - datetime field End - datetime field Parts - text Remarks - memo - DutyRate DutyRec - autonumber - primary key (PK) DuID - number - (FK) Rating - (Yes/No) Pass/Fail JOB - autonumber - primary key (PK) Description - text EstTime - number - single - estimated hours EstLabor - number - single - estimated employees - Duties DuID - autonumber - primary key (PK) Name - text HowTo - memoor hyperlink to Step-By-Step Instructions Safety - text or hyperlink to safety information "ccful" wrote: I'm trying to decide on the best way to design a database that will be tha majority of yes / no values for instance i have a multiple jobs for one piece of machinery and under the job there are multiple duties that could be done and a rating for each dutie . There are 14+ items that have this format Any suggestions or help is appericated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Continuous corruption of database | Keeler | General Discussion | 14 | November 1st, 2005 07:11 PM |
Creating a recordset of a table in an external database | Shadow | General Discussion | 4 | March 28th, 2005 02:11 AM |
Creating a recordset of a table in an external database | Shadow | New Users | 4 | March 28th, 2005 02:11 AM |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |