exact update with related field

[dmartens]

Help! This works with Filemaker 5, but I can't get it to work in 5.5.

I have an Information Database, related to a Users Database. I have set the Web Security db to exact search by the UserName & UserPassword fields in the Users DB. Here users can edit their own password/authentication information.

The Information DB is set up in the Web Security db to exact search the Users::UserName & the Users::UserPassword fields. I have also set it to exact update with the Users::UserPassword field. This way users can only view their record & I can require them to enter their password to edit.

Here's the problem. In FMP5.5 when a user edits their information with Users::UserPassword, the web companion creates a new related record in the Users DB. When I specify Users::UserPassword.1=password it says I don't have edit privledges. Is there a solution to this problem?

[Anatoli]

The exact functions are very very explicit. You must observer their exact values and logical conditions in every step. They do yield better security over the web, but are not really very practical in normal web browsing.

[dmartens]

But I have followed the exact syntax. It works in FMP 5.0, but not in 5.5. The Security privledges work correctly. Users are able to edit when they exactly match the required field. The issue is that it creates a new related record every time you edit. How do you keep it from doing that??

[Garry Claridge]

You may want to double-check your 'Define Relationship' settings and the Portal settings. Something may have changed there!

All the best.

Garry