combine related file records into 1 field

[GoAng]

I have one file for Employees which is related to "Groups" by a unique#. One employee can be a member of multiple groups. I need to send an email to each employee detailing what groups they're a member of. Is there an easy way to show the related values from Groups into a text/calc field for the the related employee? In the past I've used a script to copy the values from a portal to one field but would love an easier way.

thank you!

[GoAng]

I have one file for Employees which is related to "Groups" by a unique#. One employee can be a member of multiple groups. I need to send an email to each employee detailing what groups they're a member of. Is there an easy way to show the related values from Groups into a text/calc field for the the related employee? In the past I've used a script to copy the values from a portal to one field but would love an easier way.

thank you!

[GoAng]

I have one file for Employees which is related to "Groups" by a unique#. One employee can be a member of multiple groups. I need to send an email to each employee detailing what groups they're a member of. Is there an easy way to show the related values from Groups into a text/calc field for the the related employee? In the past I've used a script to copy the values from a portal to one field but would love an easier way.

thank you!

[Brian C]

The answer to this is, yes I think so. If you have a relationship to another file, you can create a return delimited listing by:

1) Create a value list in the parent file which has it's content based on the relationship of your choice.

2) Create an unstored calculation field and use: ValueListItems ( fileName ; valueList )

This will allow you to display a CR/Pilcrow delimited list of groups. From here you should be able to drop this into a letter using the field merge.

If you want to change this all to be displayed on one line, just encapsulate the ValueListItems function inside of a Substitute ( text ; searchString ; replaceString ) function and set it so the CR will be replaced with a comma or something else of your choosing.

[Brian C]

The answer to this is, yes I think so. If you have a relationship to another file, you can create a return delimited listing by:

1) Create a value list in the parent file which has it's content based on the relationship of your choice.

2) Create an unstored calculation field and use: ValueListItems ( fileName ; valueList )

This will allow you to display a CR/Pilcrow delimited list of groups. From here you should be able to drop this into a letter using the field merge.

If you want to change this all to be displayed on one line, just encapsulate the ValueListItems function inside of a Substitute ( text ; searchString ; replaceString ) function and set it so the CR will be replaced with a comma or something else of your choosing.

[Brian C]

The answer to this is, yes I think so. If you have a relationship to another file, you can create a return delimited listing by:

1) Create a value list in the parent file which has it's content based on the relationship of your choice.

2) Create an unstored calculation field and use: ValueListItems ( fileName ; valueList )

This will allow you to display a CR/Pilcrow delimited list of groups. From here you should be able to drop this into a letter using the field merge.

If you want to change this all to be displayed on one line, just encapsulate the ValueListItems function inside of a Substitute ( text ; searchString ; replaceString ) function and set it so the CR will be replaced with a comma or something else of your choosing.

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe

[Ender]

Off topic.

silose, start your own thread!

[Ender]

Off topic.

silose, start your own thread!

[Ender]

Off topic.

silose, start your own thread!