In a previous post I merged two tables a tblBranchID and tblPersonnel. Now there is just one table, tblPersonnel. It contains everything that the original tblPersonnel contains, plus two new things a branch identification fileld and whether or not that person is or is not a branchhead. That make one table able to hold all of the personnel.
It does change some things, however. For instance. I have a combo box on another form and its control source is a field on the Branchhead table. That table is no longer.
I must change that combo box. But it is not enough to say are they in the tblPersonnel. of course they are. That worked very well when all of the brancheads had their separate table.. The question should be are the on the tblPersonneland and are they or are they not a branchhead.
I will use the yes/no control, but I still must account for it in the combo box on said form.
Is this correct and how do I change that combo box to reflect the change?
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed