from many to one

[minnesota1972]

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

[bcooney]

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).

[minnesota1972]

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.

[bcooney]

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.