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 to requery in FM?

Aztra
in Relationships

Featured Replies

  • Newbies

Basic question from a Nube.

I have a simple PO system set up, only 3 tables. I have PO, customers and locations.

On the PO form ( the main one) after I chose a customer I want to select the location from a list of locations that have a relationship to the customer selected.

To do this I used a Pop up menu and set it up to pull data from the locations table.

The issue is when I call up the table it only shows one location. If I save it, close it then open it up again all the locations will show up in the list.

Since Im new to FM I not sure how to have this data refresh without have to close the data base. In Access I would just use a simple Requery command.

"To do this I used a Pop up menu and set it up to pull data from the locations table."

What does this mean?

Please try to provide more information when asking questions.

You perform a find? You have a relation and portal based on this field? You have a lookup? ??

  • Author
  • Newbies

Thanks Bruce.. I figured out my error..

Create an account or sign in to comment

https://fmforums.com/topic/74716-how-to-requery-in-fm/
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.