Showing Unique Records Only in Portal

[jill]

I'm trying to have a portal show only the unique records, instead of every record, but not having much luck. Here's what I've got:

Databases:

Orders - main entry of order, has portal of Items which are related by Order Number.

Items - each separate item in the order, includes the vendor and item ID.

I want to create a portal that will show all the vendors used on an order as the same vendor can be entered on the order multiple times.

I did manage to make a calculation which returns all the vendors from a relational value list. But I can't seem to relate this calculation in order to show the values in a portal. I got this tip from an earlier post, but maybe it's not the direction I should be taking.

[transpower]

Set up a separate vendor-order table, related to your order table. Then have a portal to this new table.

[jill]

Not quite sure how to set this up right.

If I create a new table, Vendors for Job and put the following fields in:

Order Number

Vendor

Then how do I get the new table to show only the first occurance of each vendor for the order? I'm a little confused on this.

[-Queue-]

See here for a possible solution. Do a search for +summarize +portal if you want more threads where this has been discussed.

[jill]

Well, I just did a bunch of searching and trying, but I'm just not getting it. I think I have a brain block on this one.

I can't seem to figure out how to create a vendor_order table related to the order table since there are no vendor records in the order table, only in the item table.

From past posts, I got the relation value list to return a single occurance of each vendor, but how do I get that in a portal?

Thanks for any help.

[-Queue-]

You could try creating an unstored calculation text field of ValueListItems( Get(FileName); "yourvaluelist" ), where yourvaluelist is based on related vendor id and create a relationship from this field to the id field in your vendor table. A portal using this relationship should only display unique vendors.

[jill]

That did it. Thanks a bunch.