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.

Importing especific info from SQL

Featured Replies

My Situation:

I have already many products registered into my filemaker database each of these products have a price and this info in a SQL Server. How can i link each price to each already filled record?

So i need to import especific data from especific fields from sql to each of my already filled records in filemaker. What i need is kind a link between each field of each record to each one in SQL.

Is that possible?

Well there are two different things here.

First there is a SQL statement that you can run on an import.

OR

With FM9, you can now use the ESS feature. If you have a matching Unique Product ID in your SQL table, you can simply just create a relationship between that field and the filemaker table field. Then you can have "live" prices.

It all really depends on what you are trying to achieve and if you really want the data within a filemaker field via an import (or can use set field in ESS).

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.