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.

How do I 'make' FM match source and target tables?

ron G
in Importing & Exporting

Featured Replies

This hasn't been a problem until now.

 

The source and target both have a table called GLOBAL.  When I try and import into the Target Global FM shows a source of Members.  I manually select a Source of GLOBAL. It imports.  All is well..... until I run the import script again and then the Source reverts back to Members.  I can not get FM to use a matching Source and Target .... grrrrr !

 

Waz going on? ????  What is the 'trick'?

 

 

post-72145-0-34932800-1375814859_thumb.j

 

  • Author

Here is something else that seems counter intuitive:

 

post-72145-0-60713500-1375816987_thumb.j

 

post-72145-0-00061600-1375817063_thumb.j

 

No matter how often I specify Matching Name Order instead of Last Order, FM insists on putting things in 'Last Order'.    When in 'Last Order' FM (for reasons not apparent to me) does not import  or match some fields like Desc_PM1 field.  But, when in Matching Names order, everything works.

 

So, how do I 'command' FM to put and keep things in Matching Name Order? 

 

Thank you.

 

 

  • Author

Solution:

It appears that the Matching criteria is set from the script import step.  FM has no 'memory' on runtime.  Lesson learned.

Create an account or sign in to comment

https://fmforums.com/topic/89292-how-do-i-make-fm-match-source-and-target-tables/
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.