Hi,
I have a question regarding diplaying data from two tables on one form. I have set up two tables in a 1 to many relationship where one 'Name' may have many 'documents' associated with it
table1
Name
rank
serialnumber
Table2
serialnumber
document
Forms
First is a list form that uses DB multi Recordloader as per the tutorial and includes a link to a second form as per the tutorial and this works just fine!
Second form is the "View" form. I use first a DB recordloader to load the information from table1 again using the tutorial to display the record. Then below it in the same form I use multirecord DB loader and the auto display to display the records from table2 that are associated with the serial number from table1. All of this works however the records from table2 display before the record from table one, in the form. So my question is 2 part. First is this really the best way to display data from two tables on a form, and if so, how do I get the record from table1 to display on top of (or before) the records called from table2 in the form.
I did see the data view tab found when you click on the name of the form but could not figure out how to make use of it?
I am using Chronoforms 4.0 RC3.21
I appreciate any help you can offer!
-Donald
I have a question regarding diplaying data from two tables on one form. I have set up two tables in a 1 to many relationship where one 'Name' may have many 'documents' associated with it
table1
Name
rank
serialnumber
Table2
serialnumber
document
Forms
First is a list form that uses DB multi Recordloader as per the tutorial and includes a link to a second form as per the tutorial and this works just fine!
Second form is the "View" form. I use first a DB recordloader to load the information from table1 again using the tutorial to display the record. Then below it in the same form I use multirecord DB loader and the auto display to display the records from table2 that are associated with the serial number from table1. All of this works however the records from table2 display before the record from table one, in the form. So my question is 2 part. First is this really the best way to display data from two tables on a form, and if so, how do I get the record from table1 to display on top of (or before) the records called from table2 in the form.
I did see the data view tab found when you click on the name of the form but could not figure out how to make use of it?
I am using Chronoforms 4.0 RC3.21
I appreciate any help you can offer!
-Donald