In an Edit Form, I have a select statement that picks up one field named systemName according to the uid of the record that's chosen to edit. I want to upload a file to a folder (that's already been created) with that systemName. I have used FileUpload and it works fine, but I can't seem to get the path attribute to pick up the systemName. I need to obviously have a path already created, then add the systemName to that string. I've tried using a parameter in a ListDataSource, but that wasn't working. The simplest idea was to use JOIN, which I have done, and it seems like this would work easily, but it's not. I KNOW that the form picks up the fieldname correctly because I have it displayed in a textbox. But how do I put it in the path attribute for JOIN? When I upload, it puts the file in the hard coded foldername, but NOT the dynamically generated foldername/systemName/ like I intend.

Here's a fiddle:

http://dnndev.com/fiddle/fid/546