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.

Copying Value Lists

Featured Replies

Is there an easy way to copy (or move) value lists from one data base to another?

The easiest way is to choose the option "Use value list from another file" (at the bottom of the Edit Value List dialog box). Aftreards you can choose the file, where the value list resides in and use it as if it were in the actual file. But this needs the external file to be still present.

  • Author

Roger on that, However, I have 60 value lists in file A that the other files refer to and I want to move the 60 value lists to file B. I can do it manually one at a time, I thought there might be an easier way....

Thanks

This might be crazy but it's worth a try. Set up a separate file which has one field per ValueList and one record. Set the fields to

ValueListItems(dbname, valuelistname)

I'd script that.

Then move your new file 'over' to your new project and define all your valuelist as being from fields.

If that doesn't work you could try this -

identify the longest VL and its number of entries.

Create a record for each value item (using a LeftWords/RightWords calculation on the result of the ValueList Items.) Loop through this file as you run through the other VLs and drop their values into successive records.

Sounds complicated but it isn't really. The benefit of scripting it all is that you can repeat it if you change the original VLs.

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.