Excuse me, it's late in the day and late in the week, so if this is confusing, let me know and I'll try to clarify. I'm trying to figure out how to automatically fill in some data.
Okay, so we have employees, and they each work in a job which is classified by it's title, Classification Code (unique for the title) and a Position #, which is unique for each job. (For example, we can have four Secretary I positions, they all have the same class. code, but each has a different Position #.) (The Position # is the primary key, and the Class Code is linked to another table that has the ClassCode as primary key and the Title.) It also has the office that the position is located, and each office has it's own CostCenter number. (There's a table with CostCenter as PK and then office.)
I'm working on a db that was already constructed, and trying to fix it. I added the tables for ClassCode and CostCenter. The original db didn't have the Class. Codes at all, but had Cost Center *and* Office in the primary table. I'm thinking I should delete the "Office" field in that table.
Anyway, both the "Cost Center" and "Office" fields have to show up together on the forms, and I'm going to use a combo box to look up the Cost Center. How can I get it to automatically fill in a field labelled "Office." as soon as "Cost Center" has been entered? And if you change the Cost Center, the Office also needs to change. I tried doing this with two columns in a combo box, but it wouldn't show both items once selected and the people in Personnel would rather have them be two separate fields.
Also, is it possible to change them the other way around? So, if you wanted to enter the Office, the cost center would change?
Thanks in advance for any help. If this is totally daft a question, I apologize... as I said, it's late in the week and I've been trying very hard to work this whole database out so that it works efficiently and is normalized and won't give any trouble. This is only my 2nd db, and the first was much less complex than this one is going to be.
--Sara
Okay, so we have employees, and they each work in a job which is classified by it's title, Classification Code (unique for the title) and a Position #, which is unique for each job. (For example, we can have four Secretary I positions, they all have the same class. code, but each has a different Position #.) (The Position # is the primary key, and the Class Code is linked to another table that has the ClassCode as primary key and the Title.) It also has the office that the position is located, and each office has it's own CostCenter number. (There's a table with CostCenter as PK and then office.)
I'm working on a db that was already constructed, and trying to fix it. I added the tables for ClassCode and CostCenter. The original db didn't have the Class. Codes at all, but had Cost Center *and* Office in the primary table. I'm thinking I should delete the "Office" field in that table.
Anyway, both the "Cost Center" and "Office" fields have to show up together on the forms, and I'm going to use a combo box to look up the Cost Center. How can I get it to automatically fill in a field labelled "Office." as soon as "Cost Center" has been entered? And if you change the Cost Center, the Office also needs to change. I tried doing this with two columns in a combo box, but it wouldn't show both items once selected and the people in Personnel would rather have them be two separate fields.
Also, is it possible to change them the other way around? So, if you wanted to enter the Office, the cost center would change?
Thanks in advance for any help. If this is totally daft a question, I apologize... as I said, it's late in the week and I've been trying very hard to work this whole database out so that it works efficiently and is normalized and won't give any trouble. This is only my 2nd db, and the first was much less complex than this one is going to be.
--Sara
