Portal with Privileges not showing on server

[hayesk]

Using MacOS X, FMServer Adv 7.0v2, connecting with FMDev 7.0v3 on MacOS X(different machine).

I have a Name table and a Gift table. On my Name table's main layout I have a portal to Gifts. I want it so that the user does not see their own gifts. So I have the View privileges set to

GetAccount(Name) != Name in the Name table (with the proper "doesn't equal" symbol)

and I have

GetAccount(Name) != NameTable::Name and IsValid(NameTable::Name) in the Gift table.

If I view a layout from the Gift table, it works fine. The user sees all of the records except his own. But if I look at the Name table's layout, the portals are blank for every record.

Here's the weird part: If I take the file off the server and open it locally, the portals display the data where they should.

Also, if I remove the restrictions from the Gift table (i.e. set them to all viewable), the portals work, but of course, the user can see his own gifts too.

So, why would this work locally, but not on the server?

Thanks.

[Wim Decorte]

Instead of setting this in the view privileges, you could build it into the relationship defenition.

Make a relationship with 2 criteria:

- one for the gift match (=)

- one (<>) from the stored accountname to NameTable::name

[hayesk]

Thanks, that's not a bad idea. I'll try that. But I still wonder why the database works correctly locally, but not on the server.