Shared, Common And Different VL In Each Record

[Johnonepoint0]

[color:"blue"] Hi2 All

Each record in my db may embed no file, 1 file or as many as 5 files.

Like *.Doc, *.PDF, *.SWF, *.EXE, *.SXW files.

I would like the user to choose which file format to export from the container field via a value list.

Now record 1, might have *.SWF, *.EXE and *.DOC

Record 2 might only have *.DOC

Record 3 may have *.DOC and *.PDF

Record 4 may have no file to export.

Anyways, the main problem is once a value is a member in the list, if won't go away in the next record, where the values are may be different.

The value list seems to inherit the values of all the previous records into the current record.

Like record 2 will show *.DOC and *.PDF, after I goto record 3 then back to record 2.

For 2 days I have been reading page after page of posting and experimenting with relationships, and calculations to achieve this... to no consequence except to confuse myself further.

I know I have read the answer, just can't get the logical visualization in my head.

I am using "Use values from field" for the value list cuz I may need to update the value list sometime in the future with new file types.

I have used a button over the field that has the value list to set the value list source field to empty and then repopulate it with the restricted values but it take 2 clicks on the button to work and then not very well.

Mostly I have been trying to put the different value lists into different fields and and use a relationship with a matching field to establish which of the 5 different value list fields is related to the current record.

I could go on with the useless blah blah of what I have tryed but none of it worked, I really down the Rabbit hole on this one.

Anyone can give me a hint? I would surly appreciate it.

Thanks in advance.... John 1.0

[Søren Dyhr]

Yes we had it up just a few weeks ago....when I shame on me - hijacked the thread almost:

http://www.fmforums.com/threads/showflat.php?Cat=&Number=133777

...with the upload.

http://www.fmforums.com/threads/download.php?Number=133792

--sd

[Johnonepoint0]

Hi Soren

Thankie for your time.

I checked Dwindling.fp7 and didn't really get where my post's situation and Dwindling's output have in common?

I am not saying there isn't a commonalty and a solution/ answer in Dwindling.

I just don't get it.

Looked at the script, rels, fields and the auto-enter cal.

Can you shine a little light and give me a clue what I should be looking for or at?

Hey thanks again for your time and patience...... John 1.0

Thanks ... John 1.0

[Søren Dyhr]

I misunderstood - I've made a template which probably are a little closer to what you're after:

--sd

ChooseFormat.zip

[Johnonepoint0]

Hi Soren

Hey many thanks for the attachment, I looked it over for an hour and I think I understand what you did and how it works. I would have never thought of this approach, I was complicating the situation way to much.

The script worked properly for the first two container rep fields, however if the selected extension (from the value list)was in the third or subsequent fields the script failed and would default to the second container rep field and then open rep 2 for export.

So, I took out the Else If and put all Ifs. Worked fine.

I don't know why Else If didn't work. I went through it with the debugger and couldn't see why it didn't progress past the second field.

Right now I gonna make a Loop script and dispense with the IFs.

Thankie again, I would have never come close to figuring third out w/o your help.

........... John 1.001

[Søren Dyhr]

So, I took out the Else If and put all Ifs. Worked fine.

I don't know why Else If didn't work. I went through it with the debugger and couldn't see why it didn't progress past the second field.

I didn't check the taborder Sorry!...the else-if'ish structure is a case-similar structure to put the Export statement out of each condition in a "bleed throug", to improve the readability and shorten the script.

--sd

[Johnonepoint0]

Me Again

I will check the taborder, I never thought to do that.... Thanks John 1.01