October 6, 200817 yr 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?
October 6, 200817 yr 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