I am wanting to pull in selected records from a 2nd databse into a Text List in the primary database. In the Query Box for the Text List Options on the1st db, I am thinking that a ««LocationCode»» = «LocationCode» should work if the Database is set to the remote database. But nope. I was going to try
?(««LocationCode»» = «LocationCode»,ExportLine(),"")
A simple ExportLine() pulls in the current record as many times as there are records which makes sense but I want a specifc selection of record’s data.
Using the Relational Workshop, I can see the records and data that I want with the formula:
arraybuild(cr(),“Activity Log”,|||datepattern(Date,“MM/DD/YY”)+tab()+Time+tab()+User+tab()+Action+tab()+Purpose+tab()+Result+tab()+Unknown|||,|||««LocationCode»» = LocationCode|||)+ignore("",LocationCode)
but I can not see how to use that array as my datasource for the Text List. I haven’t been able to find anything in the Help with any example that would assist.