I'm trying to link two Progressive tables where three fields in one table link to a single field in another table. Also, there are underscores between each of the three fields in the first table. For example:
table1.index + "_" + table1.docnum + "_" + table1.custnum = table2.key
I was able to make this work on my SQL server by going to Database -> Show Sql Query and modifying the SQL query. However, I can't do this with the Progressive database since the box is uneditable.
I'm desparate to get a solution as this is for a customer. Any help would be greatly appreciated.
table1.index + "_" + table1.docnum + "_" + table1.custnum = table2.key
I was able to make this work on my SQL server by going to Database -> Show Sql Query and modifying the SQL query. However, I can't do this with the Progressive database since the box is uneditable.
I'm desparate to get a solution as this is for a customer. Any help would be greatly appreciated.