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.

Copy records between tables

mleiser
in Importing & Exporting

Featured Replies

I have a single table database. I want to make it relational. To start I want to copy all the records from table A into table B. In the table tab I can copy and paste and end up with a second table identical to the first with all the same fileds but no data. I want to duplicate the data as well. I don't know how to do that. After that I'll massage each one to make it relational. Bottom line I want, at first, two identical tables within my one database. Ideas?

Each Table is a different File.

You can copy and paste the fields, but the data will have to be imported into Table B.

HTH

Lee

Edited by Guest

You can import the data into a new table in the same file (select New Table as the target in the import dialog). This will duplicate the data AND the field definitions.

Create an account or sign in to comment

https://fmforums.com/topic/63465-copy-records-between-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.