Value List change

C

Conrad Santiago

Hello fellow scheduler
This is my first message to this forum. I look forward to being a contributing participant

Here is my problem. I customized a text column field. I have a value list of 5 entries. These entries have been used and are now part of the data for this field. What I want to do is remove two of the entries and add two more. I did this by customizing the value list. Now, when I right click on the column header and look at the value list, the entries are correct. The two entries are gone and the two new ones are there. However, when I click on a cell within the column and open up the pulldown list, the entries make up the old list

How do I make the new entries show up on the cell pulldown list
 
G

Gérard Ducouret

Hello Conrad,

Before the change of the value list, you have to validate, in the "Value
List For..." dialog box, the "Restrict field to items in the value list"
check box.

Gérard Ducouret

Conrad Santiago said:
Hello fellow scheduler,
This is my first message to this forum. I look forward to being a contributing participant.

Here is my problem. I customized a text column field. I have a value
list of 5 entries. These entries have been used and are now part of the
data for this field. What I want to do is remove two of the entries and add
two more. I did this by customizing the value list. Now, when I right
click on the column header and look at the value list, the entries are
correct. The two entries are gone and the two new ones are there. However,
when I click on a cell within the column and open up the pulldown list, the
entries make up the old list.
 
C

Conrad Santiago

I finally got around to applying this solution. It turns out I already had the "Restrict field to items in the value list" check box checked. What I didn't tell you was that I was working in a consolidated file. The pull down in the cells of the subprojects wasn't working. I opened one of the subprojects, copied the global version of the field to the subproject and it worked

I'm still hesitant to apply it across the board because I'm not certain if going from an "open" value list to a "closed" value list will change the values of existing cells. For example, if I remove two names from the top and add two names to the bottom, will Project correspond the value to the index of the value list entry or to the actual text

I'll give it a go and see what happens. I'll save a copy first though, hehe

Conrad Santiag

----- Gérard Ducouret wrote: ----

Hello Conrad

Before the change of the value list, you have to validate, in the "Valu
List For..." dialog box, the "Restrict field to items in the value list
check box

Gérard Ducoure

Conrad Santiago said:
Hello fellow scheduler
This is my first message to this forum. I look forward to being contributing participant
list of 5 entries. These entries have been used and are now part of th
data for this field. What I want to do is remove two of the entries and ad
two more. I did this by customizing the value list. Now, when I righ
click on the column header and look at the value list, the entries ar
correct. The two entries are gone and the two new ones are there. However
when I click on a cell within the column and open up the pulldown list, th
entries make up the old list
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top