how can i have a value list that ...

[alimrb]

how can i have a value list that when i edit a value of the list, all of the fields with this value update automatically.

[ernst]

>> all of the fields with this value update automatically.

DO you really mean all of the fields?

Or all of the records where a certain field (let's call it 'X') has this value?

[alimrb]

if i have an item with value "a1" in a list that named "l1", and i have a filed named "f1" in a record "r1", and i use "l1" for "f1", and user choose "a1" for "f1", then change "a1" from "l1" to "a2" with "edit..." item of "l1", how "f1" automatically changed to "a2"?

[ernst]

I think you can only script this if field "f1" is in your main file.

Maybe you can put "f1" in a related file in such a wat that all records in the main file that use the same value of "f1" will actually share one related record with a certain value "f1". ?

[ovalking]

Did you find a solution alimrb?

If I've understood correctly I have the same issue.

In my database 'Project Issues' there is a field called 'Work Area'. It uses a value list based on the values in a related file's field.

If say the value list item 'Design' is changed to 'Design and Test' any records in Project Issues where Work Area field ='Design' do not change to 'Design and Test'.

This creates a problem for users searching.

Thanks, Gary

[DanBrill]

ovalking said:

This creates a problem for users searching.

I always stack fields on the layout so that the 'index' number is underneath the related text value that is seen.

The cool part is now with FM7 you can further specify field behavior so that the user enters the 'index' field in browse mode, but the related text field in find mode.