How to join two subsets of records in a value list.

[toms]

Hello All,

At our company (packaging industry) we use couple of dozens proof printing profiles. Some of them are assigned to particular clients but some are designed for general use and the CLIENT_ID remains empty.

Let's assume that we have an order from client 'X'. One of the required information is the profile. It is chosen from a dynamic list which should contain the profiles of 'X' (having 'X' in CLIENT_ID) and the universal ones (having CLIENT_ID empty).

Obviously it is very easy to display one subset of the profiles but how to display both)? How to combine them in one list?

I am not quite sure if my description is clear, maybe the attached file could help. Currently the value list "profiles" displays only the profiles of the chosen client. The question is how to (as simply as possible) add the ones with empty CLIENT_ID.

Any suggestions would be very appreciated.

ValueList.fp7.zip

[comment]

Try this:

ValueList.fp7.zip

[toms]

Thank you Comment! It works great.

[The Big Bear]

Could you do it FM 6. i am trying to do the same thing

Thanks

Louviere

[comment]

Sorry, don't have version 5/6. But the method is easy to explain:

Say you're using related values based on a relationship:

KeyField = related::KeyField

Some of the related records are 'universal' and their KeyField is empty.

1. In the related file, define a calculation (result is text) =

Case ( IsEmpty ( KeyField ) ; "Universal" ; KeyField )

2. In the main file define a calculation (result is text) =

KeyField & "¶" & "Universal"

3. Now change the relationship to match on the two new calc fields instead.

[The Big Bear]

thanks ;)