C
CAM
Hello,
In my form I have two combo boxes. The first combo box called [cboclerks]
that has a list of clerks names which is pulled from a table called
[uwclerks], which only has one field called [clerks]. The user selects the
clerks name in the [clerks] combo box not a problem so far. I have another
combo box called [cbomanagers] which pull from a table called [managers].
Now here is my problem my users are asking me if there is a way to link the
clerks with the manager so they don't have to click on the [cbomanager]
combo box. For example if the clerks select Jane Doe in the [cboclerks]
combo box, the [cbomanagers] combo box manager John Doe gets automatically
selected . I was thinking of having both the clerk with their respective
manager in one table and some how link them together on both combo boxes,
but I not sure if I am going in the right direction. Any tips will be
appreciated. Thank you in advance.
In my form I have two combo boxes. The first combo box called [cboclerks]
that has a list of clerks names which is pulled from a table called
[uwclerks], which only has one field called [clerks]. The user selects the
clerks name in the [clerks] combo box not a problem so far. I have another
combo box called [cbomanagers] which pull from a table called [managers].
Now here is my problem my users are asking me if there is a way to link the
clerks with the manager so they don't have to click on the [cbomanager]
combo box. For example if the clerks select Jane Doe in the [cboclerks]
combo box, the [cbomanagers] combo box manager John Doe gets automatically
selected . I was thinking of having both the clerk with their respective
manager in one table and some how link them together on both combo boxes,
but I not sure if I am going in the right direction. Any tips will be
appreciated. Thank you in advance.