Hello all

This is somewhat similar to one of my previous post... just slightly different parameters

I have records in a table with 3 fields (yes, I'm being generic):

ID Person Fruit

1 John Apple

2 Terry Banana

3 Rosencrantz Apple

What I want to do is populate a single field with text from Person:

But I only to list the names where fruit = apple

So far what I've figured is this:

create a script where a variable is set

then loop thru the records setting the variable along the way.

they use that variable to populate a field

Is there a simpler way to do this?

Any suggestions are greatly appreciated.

John

Actually, create a calc field, result text, if (Fruit="Apple"; Person, "")

btw, it would be best if the "fruit" field contained an ID for the type of fruit (you need a fruit table, ID Desc).

Hello

I can see that I skipped sometime in my original post:

I wan the output to my field to be combined:

John, Rosencrantz

BTW: I do have an ID for my Fruit as well. Perhaps I should not have oversimplified my example.

Thanks for your help. Any thoughts on my output?

John.

Yes, please tell us the reality. Also, it's important to know from what context you are trying to derive this list of records. For example, I can look from another table thru a relationship to this table by FruitID and using List ( ) and Substitute ( ) create your desired list of names.