value list from calculated field

[The Big Bear]

Hi all

I have created a calculated field using the fields "process & process1" with a carriage return between them. I called this field "list". I created a relationship between the fileds called "process3 & list". Then I made a relationship between the fields "process3 and list" and then created a value list using this relatioship and chose the option use only related value then i attached the value list to the field "process3. the value list is very inconsistance. the list somtines displays the correct value, sometimes it displays an extra value and other times the value list is blank.

Any ideas of what iI am doing wrong. I ahve attached an file that i have made for an example.

Any help will be grreatly appreciated.

Thanks

lionel

valuelist.zip

[Søren Dyhr]

Any ideas of what iI am doing wrong. I ahve attached an file that i have made for an example.

Before dwelving into you file, must a fact be established ...can the calc be made stored or not??? You're only abel to make lists work when the field can be turned away from unstored, so if a global field is part of the calc ...won't you idea work!!!

Dynamic valuelist can be made over relations, though!

--sd

[The Big Bear]

Hi Dyhr

The calc is not stored. But never though of the gobal filed. Will try

Thanks for the reply

Lionel

[sbg2]

- Create a new number field called ID. Click the Options button and on the Auto-Enter tab select Serial Number.

- Create a new record and define your Process, Process1 fields

- Create a new table occurence (Relationship) of the Master table and call it VL_Process. Link the Master Table Occurence (TO) & the VL_Process TO by ID = ID.

- Define a new value list - Process2_6. Use values from field VL_Process::list, show only related values starting from Master TO.

- Assign the Process2_6 Value List to your process2 field and go to the newest record (in browse mode) you created to see the results.

You started off on the right foot with the list calculation. You were just not getting the part where you were relating the records.

Since you only want to show values in the list from the current record you need a unique field identifying each record (hence the Auto-enter Serial field - ID). Then when you create a second Table occurence of Master (VL_Process) and link the ID's only the current records list definitions are related.

*** Your next problem will be the list doesnt show any values until the user clicks on a blank portion of the form (outside of a field). You can make the Process2 field a button that will trigger a Commit Record & a Go To Field [Process2 ] step, this will enable the Value List items but what do you do if users Tab into the field? Now you have to uncheck the Allow Field To Be Entered In Browse Mode option under Field Format for Process2 (and 3, 4, 5, 6). Welcome to the wonderful world of Filemaker. Maybe there is a way to get them to update correctly, but it has me stumped.

Edited August 8, 2005 by Guest

[The Big Bear]

sbg2

Thanks

Lionel

[The Big Bear]

worked like a charm

thanks