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.

Featured Replies

I'm not sure this is the right forum but I give it a try here.

I have two costumer databases where each customer have a unique customer number.

How can I compare the two databases and find if some customers are registered in both databases?

Create a calc field in which you will determine the exact criteria for what you consider to be the same customer. Possibly, Name&Address&City, etc for both files.

Then create a file reference to the second file and use those two calc fields as they keys in a new relationship. Next create a layout that shows the records from the Table occurence of the second file. Then you can use Go To Related Record [show only related records; Match found set]

  • Author

I don't know if there was a missunderstanding. I have 2 databases / 2 files that I want to compare.

Could you help me with this (and get paid) plase? It will take to long time and to many questions to do it my self. ;)

Before we go any further, the unique customer number in the two databases are they the same for each customer in both databases?

  • Author

Yes

Well if that is the case, then you wont need to create the calc fields. Just do this.

Create a file reference to the second file.

Put a copy of a Table Occurence from the second table (in the Relationships Graph) and create a relationship from the first file to the second file keying on customer number in each file.

Next create a layout that shows the records from the Table occurence of the second file.

Then you can use Go To Related Record [show only related records; Match found set]

  • Author

I want to ask you again if you have the possibility to make it for me for a fee please?

Zip and Post your files. I dont think it is necessary to pay a developer for this; unless there is more to it that you have not conveyed.

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.