What do you mean by a "header link"? Can you give an example?
Off hand, what you would do with a single file should also be possible with the data and interface separated.
I'm sorry. What I mean with header link is just a column header... ex: Company Name, Address, State, etc...
I thought that a single file and multi file would work the same but for some reason what I did did not work..... Maybe it is because the table does not exist in the interface file?
Yes, but how are you using the column headers to sort the values in your portal?
Or have you replaced a table view in your original system with a portal in the two file version?
The column header is a button that triggers a script that sends a script parameter with sort filed. (ex: accountname, state, timezone, etc)
And also, in the "Edit Relationship" window, I checked the Sort records checkbox and specified a global field with what to sort with...
It is actually a solution provided by Landon. Here is his movie...
But anyways, what the script does is sets a variable $sortfield with script parameter in the button, and then sets the sortorder and sortfield.
At the end of the script, there is a Refresh Window command and refreshes the portal with new global field variables set in the Relathionship window.
I'm familiar with the method, but it's not the only way to sort records in a portal, so needed to be sure that was the method you were using. I don't see why that would work any differently when you have a multi-file solution instead of a single file. Where does this break down for you?
Well, it looks like its not really sorting in the relationship part... I don't know if it is because I have a cartesian join table? I used the "x" instead of "=" becaue I am using the same table "accounts" to join each other with it's primary key...
You'll need to check and see why that is. The portal should sort the same way whether the portal records come from the same file or a different file than the layout's table.
Check the sort setting in Portal Setup...
Check to make sure that the correct values are being passed to your script and assigned to the global field.