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.

creating relationship from a popup

Featured Replies

What is the elegant way to create a relationship using key fields using a popup menu and without showing the key field in the popup?

What I do now is make sure the popup field (drawn from the to-be-related record, say, a product name) is useable as a temporary key and place it in the originating record. This defines a temporary relationship using those two fields. The foreign key field in the originating record is set to auto-enter the other's prime key using the relationship defined by the popup entry and then the key-field relationship is used exclusively after that.

This works but it's a kludge. It requires a field that is only used for that purpose and that field winds up duplicating data in another table. It also exposes the link for a brief time to all the problems that come with not-necessarily-unique link fields.

Is there a more-elegant way to make that link using a popup without showing the key value (yuk!)? I'm sure this has been answered somewhere in this forum, but my searches either came up empty or found more than I could wade through.

You can have two fields in the popup (the key and the descriptor, say); you can then graphically "hide" the key; maybe Lee can find a forum reference or two for how to do this.

  • Author

you can then graphically "hide" the key;

How would I do this? I don't want the user to have to see the key at all. Certainly not on the layout but also not in the popup.

Create an account or sign in to comment

Important Information

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

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.