Hi guys I am trying to get data from another table
I used this but is not showing up in the form???
ANY(SELECT(PM Permits[BOC number], ([Permit Date] = [_THISROW].[DATE])))
should I use a text format or list??
when I use list is says only virtual column can use list
when i use a virtual column it does not show either?? also I don’t want to use a virtual column because I want the data to be written to the sheets from the form completion
am I doing this wrong is there a easer way
thanks in advanced for the help