I have two Tables: Hosting Requests and Video Files
In the Hosting Requests table, the user can create a request to host a video file.
What I would like, is to have two options for them at the same time:
1. Add a new video file (which would open a window where they complete a video file form).
2. Select an existing video file (which would also open a new window where they could select (from a drop down list) an existing video file.) They could click this button as many times as they would need to select all of the video files they want to host.
I would then like a summary report that lists all of the video files associated with this hosting request.
(These video files can be hosed in many places, which is why there could be more than one Hosting Request for each video.)
I have set up a 1:many relationship (1 Hosting Request to Many Video Files) which has accomplished #1 above. How do I create a button to do #2 above?