Re: possible to create a cl on this?

[Booth Martin <booth@xxxxxxxxxxxx>]

Go the quick extra mile.  Create a Closer file, make it user editable, 
and then use a join to get the records you want.

Here is how I solved a similar situation.

http://martinvt.com/Subfiles/Dropdown_Box/dropdown_box.html

On 6/24/2015 5:09 PM, Hoteltravelfundotcom wrote:
> I have created some views, 3 of them which gets the data needed as the
> basis for some reports.
>
> The database does not have a category for sales person type.
>
> We have a sp type called a closer. Every so often someone else is moved up
> to closer.
>
> I then have to hard code the closers USERID in the first view, then simply
> recreate the second and third. Then the reports are fine and have the new
> person.
>
>   I would like the user to just enter the closer USERID when they get a new
> one.
>
> But my understanding is I cannot do this in a CL. I don't want to make a
> small file of closers. How can I automate this way when using views.