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
|
|||
|
|||
Other table design solutions for storing multiple employee ID's
I have a table which holds the ID, DivisionID, Division term (ex: 2007-2009,
2009-2011), followed 10 fields (type = number) for the 10 officer positions. I have 52 divisions and 178 terms that have to be tracked (1921-2099). Each 10 Division Officers need to be maintained; for example here are the 10 offices and the EmployeeID numbers: ID DivID Term Term Pres 1VP 2VP Chaplain RS Reg. Treas. Hist. CS Lib Parl 40 29 88 4/30/2009 26694 29776 35877 32121 36207 34987 34985 36942 34863 36497 26088 41 29 90 4/30/2011 29776 35877 2461 36311 36053 36498 36575 37209 33860 36207 26694 This allows me to only have about 5000 records. If were to make the table just have a field called officer position and the the employeeid; it would cause the file to hold over 92,000. My issue is two- fold: 1) I have a combo box on the form that uses the employee number from the field to each of the 10 fields. It works fine, but the form is very slow to open -- but once open it works great. 2) I need to generate reports from this table. I need to list all of the 10 officers names. I started creating the query and linked the President field to the Employee table to get the name; but when I went to link the 1st VP that's when Access "yelled" at me. How do I link to the Employee table for each of the 10 officers in order to get their names? Is there another way? Please help. |
Thread Tools | |
Display Modes | |
|
|