I am trying to use the list function for the first time. My result is fine, except that it returns return separated values into my portal field (which I believe is what it is supposed to do). What I need is to get each of the the results into their own field.

I haven't found any discussion of this, but I could have missed it.

Any help is appreciated.

I am trying to use the list function for the first time. My result is fine, except that it returns return separated values into my portal field (which I believe is what it is supposed to do). What I need is to get each of the the results into their own field.

I haven't found any discussion of this, but I could have missed it.

Any help is appreciated.

More description of what you're trying to do would help. Since the data is apparently already normalized what is the purpose of repeating the data?

Edited September 15, 200817 yr by Guest

I am creating a Grocery List Generator that takes the info from a Meal Planner, which is set-up for each day's meal (21 per week). Each meal contains Recipes and Products. Recipes are created in another TO and use Products. I also have an Inventory TO which uses Products. Another TO is Stores which uses Products. Ultimately I want a grocery list by Store, based on the Meal Planner and Inventory.

Right now I have a portal to extract all of the Products from the Meal Planner TO. I was trying to create a portal with individual records of all the products in each Meal so that I can create the necessary relationships for my ultimate grocery list.

Besides, I figured there was an easy way to get the results in separate portal records.

Thanks.