Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

exact update with related field

Featured Replies

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?

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.

  • Author

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??

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

All the best.

Garry

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.