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.

Available/Unused numbers within rnge

Deman
in Value Lists

Featured Replies

  • Newbies

Apologize if this has already been covered but I've been looking for a while now.

All I'm trying to do is to create a value list based off a global field of available unused numbers within a set range.

I have unique serial numbers for each record but this is a housing rentals db and they are assigned key numbers per property. These key numbers are within a set range so I'm looking for the easiest way to pull up a list of numbers that are not currently being used. I created separate tables with say 1-200 auto entered serial numbers to compare my key number field to but I'm not exactly sure of the next step as far as the wording of the calc etc. If I can get list of unused numbers into a global field I'm assuming I can assign that to a value list and use it as a drop down.

Any help is appreciated. Thanks.

Using FM Pro 7

Create an account or sign in to comment

https://fmforums.com/topic/76926-availableunused-numbers-within-rnge/
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.