Relating 2 DB using a range of timestamps

[dkey]

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 September 22, 2017 by dkey

[comment]

Do you mean like this?

Archive.zip

[dkey]

Thanks a lot it works really well

Kind regards