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 create a record in database other then main?

Featured Replies

Here's a problem:

I have 2 databases, one main, and other supporting database. Main database holds information on different "things", supporting database is supposed to hold history about each "thing" in main database. In a simplified way - supporting database contains fields: id, date, place (the meaning is where each "thing" with 'id' was at a 'date')

What I need to do is, while browsing the main database, create a new record in supporting database with specified info (date, place), for selected "thing" with 'id'.

I just started learning FM, so I'm a big curious if it is possible at all to do this kind of thing (I do believe it IS possible). So, any ideas or suggestions are greatly appreciated!

Thanks in advance,

Mike

The easiest way to perform this is to have a portal in main that views the related records in your support database and allow creation of records in the relationship. Then you will find a blank row in each portal where you can input information to create a new record in the support database.

Chuck

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.