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 |
#11
|
|||
|
|||
Where to start
I'm not there ... I can't see the two tables.
And you'll need to describe what YOU mean by "compare it to the data entry table"... Regards Jeff Boyce Microsoft Office/Access MVP "131313 via AccessMonster.com" u32128@uwe wrote in message news:6e9b3bfa420cd@uwe... Now that I set up the table this way, how can I compare it to the data entry table which is the table that is entered weekly with associate training codes. There are numerous associate training records in the data base. That table includes the lab code for each of the labs they have taken. 131313 wrote: Ok, Here is what the new table looks like: LAB Code LAB Name Certificate Code Certificate Name FMS0001 FMS Week One TDP0500 Snesor & Actuator Fault TS FMS0002 FMS Week Two TDP0600 DeviceNet & SCADA TS FMS0003 FMS Week Three TDP0700 Process Control FMS0004 FMS Week Four TDP0800 Integrated Systems Fault TS TEC1500 Mechanical Lab One TDP0110 Fundamentals TEC1501 Mechanical Lab Two TDP0200 Advanced Electrical & Mechanical TEC1502 Mechanical Lab Three TDP0200 Advanced Electrical & Mechanical TEC1503 Mechanical Lab Four TDP0200 Advanced Electrical & Mechanical TEC2110 Electrical Lab One TDP0100 Fundamentals TEC2111 Electrical Lab Two TDP0100 Fundamentals Now I all the information in this table. As you can see, the course codes that are needed for the certificate have the same certificate code, is this correct? Thanks Please re-read my response. I suggested adding a table (as does Dorian) that holds the valid Certificate-Course combinations. [quoted text clipped - 12 lines] Jeff Boyce Microsoft Office/Access MVP -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200703/1 |
|
Thread Tools | |
Display Modes | |
|
|