I have an application for asset calibration , based in SharePoint and I am using a view form to display the record data. Different assets require calibrations from different calibration facilities. The main record maintains a column to identify the calibration facility for that particular asset. I have several hundred assets and less than 10 calibration facilities to keep track of. For ease of maintenance I chose to place the calibration facility address, phone and contact data in a separate SharePoint list.
A search is initiated for a particular asset and the items are loaded into a gallery from which the asset of interest is selected. This then loads a form with the asset record that contains only the calibration vendor name. I have provided a checkbox, that when checked, will allow a popup window to appear that contains a form for displaying the complete facility data set for the listed facility. However, even though the popup functions as expected I am not able to load data from the calibration facility list using this method.
My data is being loaded into collections correctly so I know I am able to access the data. I can create a text box containing the name outside of the DataCardValue for facility name in the main form. However I am not able to use a search or lookup to locate the data in the vendor list and populate the popup form. I thought I read somewhere that this particular feature is not available directly but cannot seem to locate any referenced work around that will make this concept work for me. I am trying to avoid creating galleries that will end up hidden in order to make this work if there are other ways.
Has anyone else encountered this approach and could perhaps suggest a viable workaround? My thanks in advance.