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.

View without primary key

El_Pablo
in External Data Sources

Featured Replies

Hi there,

 

I must connect a FM solution to an ERM which I only have access to a couple of views. The ESS is SQL Server 2008 R2.

 

The System DSN works fine without any problem. FMS12 is hosted on a Windows 7 x64 (I know!!).

 

The problem starts when I want to add a view to the relationship graph. Filemaker pops a window asking to choose for a primary key. The view does not have any primary key since it is an aggregation of multiple tables.

 

How can I workaround this problem?

 

Thanks for helping

If there is no clear unique key for each record in the view, FM will try to create one using combinations of field data.  If none of those produce a unique key you'll get that message.  The only way around it is to ask the SQL admins to add a key to the view.

  • Author

The DBA created a GUID for each record of the view and it didn't do anything.

  • 7 months later...

Wim,

I have the same problem, with the twist that I know that one of the fields contains unique values.

So I don't understand what you mean with "FM will attempt to produce a unique key "...? It should be able to based on what I know.

I was assuming it was not working because there was no "designated" unique key on the SQL side, is that not the case?

Create an account or sign in to comment

https://fmforums.com/topic/95125-view-without-primary-key/
Go to topic listing

Important Information

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

I accept

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.