This is a problem with a calculation, but it originated in this section of the forum, so I thought i'd ask here. I am just using the Users and Groups database now, for those who have been helping me, I got rid of the memberships database. The problem I have is with the attachment I was given. In the Groups.fp5 database, there is a field, UserIDs with this calculation:

ValueListItems(Status(CurrentFileName); "membership")

When I take this line, and use it in mine, it wont let me use the semicolon. i have to use a coma, and then the calculation does not work. Does anyone know why this is happening? Secondly, membership, in this case is refering to the value list named membership, correct?

--Mark

ValueListItems (Status (CurrentFileName), "membership")

This should work, assuming you indeed have a value list called "membership" and your calculation result is set to Text.

The semicolon is just a by-product of non-U.S. versions of FileMaker. You are correct to replace it with a comma.

Thanks, i'll take another look, and see why it isnt working, I was really worried about that semicolon though, and now I dont have to be.

--Mark

sorry, rittmark,

i do work in German FileMaker.

To have those calcs "paste-ready", just say"OK" when this nasty dialog about System formats comes up.

Its fine, I apprecieate you helping me in the first place. I just changed the semicolon to a comma, and it doesnt give me an error.

I am not having a problem, but its Lasso 6 related. I am performing a search in the groups database, using the User_Number field as the paramater, but since the User_number is inside the portal, it fails to return any records. It works perfectly in filemaker though. I just have to find a way to use this method in Lasso 6, and I will be in business.

--mark