May 19th, 2015, 11:06 AM
Ok here is an update. I have read on the forum where a user has the same issue where he cannot get data between fields in other tabs. It seems as if there is no way to lookup a column in the table because you cannot find the primary key (submission_id). It also seems as if you cannot reference field names between tabs as well. The only way i could figure out how to be able to query the database where the submission_id is the current one was to create a custom field. I was able to set the value to $SUBMISSION_ID in the "Displaying" section. I now added a new field to the second tab and set it to my new custom field. I added it to my view and it now displays the current submission_id. I was able to use the field value to query based on the submission_id.