Hi Lawrence,

Do you which table the "member_path" column is in?

If "member_path" value is the same as found in dbo.cf_bp_data then the below may help...

I have used the following SQL query to pair forms instances to their respective field values so I could generate some reporting data. Please cross-reference the values returned against Laserfiche Forms as we used it during testing in a development environment.

I believe the status = 2 was for completed forms only.

SELECT        Laserfiche_Forms.dbo.cf_bp_main_instances.bp_name, Laserfiche_Forms.dbo.cf_bp_main_instances.bp_instance_id, 
                         Laserfiche_Forms.dbo.cf_submissions.submission_id, Laserfiche_Forms.dbo.cf_bp_main_instances.status, Laserfiche_Forms.dbo.cf_bp_data.attribute_id, 
                         Laserfiche_Forms.dbo.cf_fields.label, Laserfiche_Forms.dbo.cf_bp_data.value, Laserfiche_Forms.dbo.cf_bp_data.member_path, Laserfiche_Forms.dbo.cf_bp_main_instances.process_id
FROM            Laserfiche_Forms.dbo.cf_bp_data INNER JOIN
                         Laserfiche_Forms.dbo.cf_fields ON Laserfiche_Forms.dbo.cf_bp_data.attribute_id = Laserfiche_Forms.dbo.cf_fields.attribute_id INNER JOIN
                         Laserfiche_Forms.dbo.cf_submissions ON Laserfiche_Forms.dbo.cf_submissions.submission_id = Laserfiche_Forms.dbo.cf_bp_data.submission_id INNER JOIN
                         Laserfiche_Forms.dbo.cf_bp_main_instances ON 
                         Laserfiche_Forms.dbo.cf_bp_main_instances.bp_instance_id = Laserfiche_Forms.dbo.cf_submissions.bp_instance_id
WHERE        (Laserfiche_Forms.dbo.cf_bp_main_instances.status = 2)

Thanks,

Dom

Yea cf.bp_data is the table I was referring to. I will give that query a try to see if it gives me what I need. It seems to be what I need from first glance. I will update this thread with news. 

Thanks!