Basic-Synchronizing Combo Boxes

[MICHELE]

I have been trying and trying to synchronize 2 combo boxes that are for 2 fields from the same table. I don't know if that's even possible. Eventually I would like to do more than 2 combo boxes and have any one of them synchronize with another one (whichever 2 the user wants). Right now I would just like to get started with 2. I have checked the help wizard and even read some Microsoft articles, including Q97624 on synchronizing combo boxes. I need some tips that will help me get started. Thanks in advance.

 

[MICHELE]

Thank you! These fields are related, but I'm not sure if it's what you mean. All of these fields are in one table. I have several fields on one table including: State,Drafter, and Job Type which are all related to the Job number(primary key). So if I had 3 combo boxes(State, Drafter, and Job Type), for example, could I look up all the jobs in the state of TX, then all of the Drafters for the jobs in TX(from the 1st Combo Box) eventhough the State and Drafter are included on the same table? If not, do you have any suggestions about how I could do this?
Thanks again!