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.

Relating 2 DB using a range of timestamps

  •
dkey
in Relationships

Featured Replies

Hello

I have 2 DB with the following fields

VIDEO:     CLIPNAME, RECORDED_DATE, and other fields not relevant to my question

AUDIO:     SOUNDFILE, RECORDED_DATE  etc

Unfortunately the recorded dates are different and so are the names.

I need to link the two db and I hope to find a way to relate the two files so that the RECORDED_DATE in the VIDEO file will tell me what is the SOUNDFILE recorded in the other DB

I tried to add a STARTDATE and ENDDATE to the AUDIO db to get a range of times so the VIDEO file could give me the Video FileNames recorded during the selected timestamp range

Here I add samples of the two files to make it easier for anyone willing to help

There are a few more records in the VIDEO files but this is normal while filming

VIDEO.fmp12

Audio.fmp12

 

Thanks a lot for any help and regards

Edited by dkey

Do you mean like this?

Archive.zip

  • Author

Thanks a lot it works really well

Kind regards

Create an account or sign in to comment
Go to topic listing

Similar Content

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

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.