What I would like to do is after I select a value in combo box A, I would like that to trigger a default value in combo box B while still allowing combo box B to have all its values.
That's the short of it...here are the details...
When a user selects a crew chief for a job, I need that chief's default helper to populate in the appropriate helper combo box, while still allowing the user to select a different helper if necessary. ALL workers are listed in tblCrew (CrewID, Name), while tblCrewTeams have the two man teams in each record (CrewChief, CrewHelper) based on tblCrew. I have tried a number of different ways (unsucessfully) to make this happen. So, any suggestions would be helpful. If my description is too vague, please don't hesitate to ask questions. Thanks in advance.
That's the short of it...here are the details...
When a user selects a crew chief for a job, I need that chief's default helper to populate in the appropriate helper combo box, while still allowing the user to select a different helper if necessary. ALL workers are listed in tblCrew (CrewID, Name), while tblCrewTeams have the two man teams in each record (CrewChief, CrewHelper) based on tblCrew. I have tried a number of different ways (unsucessfully) to make this happen. So, any suggestions would be helpful. If my description is too vague, please don't hesitate to ask questions. Thanks in advance.
