Hi,

I'm looking for a way of creating a value list of [record Numbers] that appear in a portal, for use in a calculation field. Can you help?

Thanks

Giles

I've managed to establish a value list, but it's returning ALL the [record numbers] in the database, rather than the [record numbers] for the found set.

I've built a series of tests (a test portal, a test "count" calculation, and a test that correctly reports the first [record number] for each set) to check that I've set up correct relationships, and they seem to be working fine. I'm using the same expressions as I did in previous DB's (ValueListItem, "fileName", "ValueList").

Any suggestions as to where I'm going wrong would be really helpfull

Thanks

Giles

ValueListItems will return the items that are already in a value list. What you need to do is create the value list in the first place. If what you want is appearing in a portal, then this good news since there must be a valid relationship in place to create that portal. Create a value list using the "use values from field" option, pointing this to whatever field has the values you want. Then set this to "include only related values" and set this relationship as whatever relationship is that is producing your portal. In FM7 you also have to assign a "starting from" table to put it in the proer context.

HTH,

Dan