Hi all, Please excuse I am having one of those “I’m sure I ahve done it but for the life of me can’t recall how” days.
We have a soldiers file with records containing a SURNAME AND SERVICE NO making unique identifiers by which all externally stored images and items are keyed. (FILE NAME = SOLDIER)
We can have none, 1 or many documents or photos which we wish to link to the soldier. Because it needs to be able to grow it has to be a second file and will contain a combined SURNAME-SERVICE NO key as well as an auto-incrementing number, image and description. (FILE NAME = MEDIA)
I have made a connection from MEDIA to SOLDIER on a basis of
SOLDIER CAN CONNECT TO MANY MEDIA
MANY MEDIA CAN CONNECT TO ONE SOLDIER
OKAY so in the SOLDIER input screen I want to be able to nominate those items which have been created in the MEDIA FILE.
Note that whilst the MEDIA file contains images they are external url links to ONEDRIVE records
However when I create a dropdown box it brings in all the available MEDIA records rather than just the ones for this SOLDIER.
I want the dropdown to show only those items that are relevant to the SOLDIER
I know there is an option to nominate what should be shown but for some reason apart from all the other options refer to the file and the current job role (media CONNECTED TO THE logged-in Researcher > SOLDIER).
That statement of being tied to the current researcher doesn;t quite make sense and I have no idea how or why it has been added.
So where have I gone wrong any clues ? Thanks in advance