but shortly after implementing the change the values list starting have additional values in it that were not in the table.
Sorry, that's impossible.
The trick in these cases is to put a copy of the field on the layout; and format it as a standard edit box.
Make sure the field is tall enough - several lines tall.
Enter find mode.
Choose "Insert from index"
Choose one of your problem values.
Perform the find.
Note that the valueListItems function returns all possible values from your value list, not the values you have selected. If the value list you are using with this function is conditional, you may need to commit records before using this function to get a list of values.
No apology necessary I am here for help and to learn from the experience this group has so thank you for the reply.
Doing what you suggested did indeed show that the field had the additional values added to it. For clarification can you explain to me why neither the data viewer nor the field on the layout updated to display the additional values without performing the find with insert from index ?
I'm not sure how you had the field displayed on the layout.
Any of the value list option will limit how much you see of actual field content.
This is a very important learning point about error checking and value list behavior; and there are things you can do to prevent this or to make errors visible.
I don't think your statement about the data viewer is correct.
If you were on the correct record; and your data viewer was displaying values from the field in question; then it WILL display all the content.
thanks for the graphics. I think I have not clearly stated my problem. The check boxes are simply for user selection and are inputs into a script to determine, which values should be stored to a second storage field. This field is referenced in a second values list which displays all the values in that field. This second values list is used in a group of pop-up menu fields. However when the storage field is empty as an edit box on the layout and in the data viewer the pop-up menu fields still have accessible values in their drop down instead of displaying no values as I would expect.
I made a short screen cast to help clarify as well.
Thanks for the reply,
I am only using the valueslistitems function with custom values lists that are not conditional. and then setting those custom values to another field in the database. The field that I am setting the values to is a part of a conditional values list that display all the values of that field. This second values list seems to be the problem as even after the field is empty pop-up menu fields using that values list have values. I added a short screen cast to my reply to Bruce if it helps clarify.
If [ PatternCount(MedMod::VSPR Model Types; "Original")=1 ]
If [ IsEmpty ( MedMod::DR Values List) or MedMod::VSPR Model Types = "Original" ]
Set Field [ MedMod::DR Values List ; ValueListItems ( "VSPR Updates Test" ; "Models Original" ) ]
Set Variable [ $Value_List ; Value:MedMod::DR Values List ]
Set Field [ MedMod::DR Values List ; ValueListItems ( "VSPR Updates Test" ; "Models Original" ) & $Value_List ]
What I saw in the video was a "use values from field" value list, that was NOT a conditional value list. It did not have the "include only related values..." option selected.
That is my mistake for the bad terminology, sorry.
Yes it is values from field not conditional, the field that it draws the values from is on the left,Dr valueslist. When that field is empty the popup menus are still displaying values and I don't understand how that can be if the field DR valuelist is empty as they values list used on the pop-up menus is from field Dr valueslist. Any clarification on how that occurs would truly be appreciated.
Thanks for bearing with my mistakes and the help and insight.
If the value list is a "use values from field" value list, It produces a unique list of values from all records in the table. The field in question (if it is the one used to supply values to the value list) would have to be empty in every record in your table before the value list would also be empty.
That is exactly the problem, thank you for the clarification on how that work and also for all the threads that you answer here because your answers have helped me learn a lot and I'm sure I will continue to learn more from this group in the future.