Avoiding Duplicates

In our company, we have multiple divisions. Within the divisions
there are branches with various cost centers, 3 digit numbers

Cost center number cannot duplicate within the same division, but
might across the company. 134 in Division EGG is Hurst Texas while
134 in Division IGG is Miami Distribution. I am when I want to add a
new cost center I add the division, then the cost center number.
EGG134 is not the same as IGG134. How do I do this? I am sure it is
just a matter of the right synapses not firing.

TK

Re: Avoiding Duplicates

In article <1191630751.754867.171090@o80g2000hse.googlegroups.com>,
TKnTexas wrote:

> In our company, we have multiple divisions. Within the divisions
> there are branches with various cost centers, 3 digit numbers
>
> Cost center number cannot duplicate within the same division, but
> might across the company. 134 in Division EGG is Hurst Texas while
> 134 in Division IGG is Miami Distribution. I am when I want to add a
> new cost center I add the division, then the cost center number.
> EGG134 is not the same as IGG134. How do I do this? I am sure it is
> just a matter of the right synapses not firing.

Assuming you already have the fields, it's a simple concatenation
calculation.
ie.
NewCode Calculation, Text Result
= Division & CostCenter


Note: This field can be either a Text Result or a Number Result, but is
potentially useless for sorting purposes - always add the two
individual Division and CostCenter fields to the sort order rather than
this one.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)