Jump to content

Tutorial on SQL and FM


This topic is 6138 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have created a scheduling program in FM (oriignally 5) for a company. I updated the views, relationships and other options when they upgraded to 8. Everything has been working great for years...until.... they went with a standalone estimating, job ticketing and inventory system that uses an SQL database. They still like the scheduling "module" in FM. Now they want me to setup a query that grabs the data from SQL and populates FM scheduling module. However, I have to make it easy for them.

In reading the posts here I was able to make the query and popluate the fields...very exciting.

How do I get only new data to import. I created a sc :) ript that makes the query and populates the fields. All relationships are through Ljob (a job number field). I want to make sure that no duplicate records are created during the query script (I guess I'll create a button that states "get new jobs")..

Any tutorials on this?

Link to comment
Share on other sites

Hi Crazybake, I've deleted the second duplicate post you just made. It isn't necessary to double-post and we would rather you didn't. We will answer your question no matter where you post - if at all possible. We read all posts anyway. :smile2:

Link to comment
Share on other sites

This topic is 6138 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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