Jump to content

how can i have a value list that ...


alimrb

This topic is 7108 days old. Please don't post here. Open a new topic instead.

Recommended Posts

>> 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?

Link to comment
Share on other sites

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"?

Link to comment
Share on other sites

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". ?

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7108 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.