Uodate Field Alternating values

[ebizleads]

I have a sales team that I need to assign leads to as they come in. Ideally, I'd like to update lead record in the Leads table in the [salesperson] field. The sales person is retrieve from the Sales Team table.

What my best approach to rotate this value fairly?

Thanks

Ebizleads

 

[CautionMP]

If the [tt]Lead[/tt] has an Id (numeric) you could use the [tt]Mod[/tt] operator and create a small function that you feed the [tt]Lead.Id[/tt] and have it return a sales person.

Does the record that contians the lead information have a numeric key field?

CMP


Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus