So I have a table, and the table has a nested table to add images.
I want to take the first related image and use it as the background in the detail view of the main form.
I have acreated a virtual column and have set that as the main image.
The virtual columns formula is this:
`any(TOP(SELECT(Maintenance Images[Image], ([ID] = [_THIS].[id]), FALSE), 1))`
Note, this expression could significantly impact sync time.
One randomly chosen value from this list (
…The list of values of column ‘Image’
…from rows of table ‘MAINTENANCE IMAGES’
…where this condition is true: ((The value of column ‘ID’) is equal to (The value of ‘ID’ from the row referenced by ‘Repair Image Detail’))
This does not seem to return a image, Am I doing something wrong?
Any help would be splendid,