Jump to content
Bill_gator

Conditional Value Lists to many ??

Recommended Posts

Bill_gator

Is there an maximum on the amount of data.?

 

i made an test version

 

Field 1 : first selection

Field 2 : based on 1st

Field 3 : based on second

 

Works perfect until i add the actual records to be done

It does do the 1st and 2nd field but shows all data in the 3rd field, not the selection based on the 2nd.

 

i allready replaced all ()[]-" etc in the 3rd field (thought problem might be there) but no sigar

 

sample data (in dutch but fields stay the same)

 

the list

 

excel

http://home.wanadoo.nl/barryleunge/add1.xls

 

FMpro test

 

http://home.wanadoo.nl/barryleunge/value%20list.fp7

 

It still works fine with the fruit and fish (vis) option

 

Does anyone know where i (it) went wrong?

Share this post


Link to post
Share on other sites
David Head

Have a look at the relationship graph in the updated file I have attached. Then look at the updated value list definition for the third field.

Share this post


Link to post
Share on other sites
Bill_gator
Have a look at the relationship graph in the updated file I have attached. Then look at the updated value list definition for the third field.

 

thx for the quick reply.

 

thing is i can't dl the file and have no option of making an deposit (no cc)

 

the text version would be nice :P

 

thx ahead

Share this post


Link to post
Share on other sites
David Head

OK, you have a self relationship from categorie to categorie.

 

You need to make another one from soort to soort (using another table occurrence of the value list table). So you will have two table occurrences connected to the original value list table occurrence.

 

Then the value list called 'geserveerd' uses values from geserveerd based on this new relationship.

 

Make sense? Much easier to see than explain.

Share this post


Link to post
Share on other sites
Bill_gator
OK, you have a self relationship from categorie to categorie.

 

You need to make another one from soort to soort (using another table occurrence of the value list table). So you will have two table occurrences connected to the original value list table occurrence.

 

Then the value list called 'geserveerd' uses values from geserveerd based on this new relationship.

 

Make sense? Much easier to see than explain.

 

Could u mail me the sample file ?

 

barryleunge@live.nl

 

again thanks

Share this post


Link to post
Share on other sites
fearspreads

Wow, you know what sucks?

This is the exact information I need to know, but I too cannot download the attachment.

 

Any chance this could be emailed to me as well?

 

feerdom@ymail.com

Share this post


Link to post
Share on other sites
AHunter3

One of the primary advantages of full membership around here is being able to download file attachments.

 

If any regular member were to email a file attachment to you, that member would be in violation of this site owner's rules. You are welcome to browse the board and post questions and read answers, but if you want the additional privileges of full membership, you have to join up as a full member.

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use