Linking Tables For use in view

[joshblevins]

I have a list of courses we offer

example here

http://www.emstrainonline.com/my-courses-3/courses-offered?group_by=courses_offered___Course_Level

When the user selects the course to view it, I want them to be able to view on a tab enrolled students, and a few other data elements that are tracked per student.

Is this possible and if so could someone please help explain it to me.

 

[Fred04]

first create 2 lists:
1) 'course' list: the one you have is ok
in this table you have has a specific id (automatically generated by Fabrik) for each course.

2) 'student' list
in this list, you have to create an element called 'courseid' that we will use later (type field; do not display). Add also an element for the name of the student...

The next step is to go back to your first list 'course' and look for the section about 'join' under the tab 'data'

then you can 'join' your main table to the student table
it will look like something like
course.id = student.courseid

repeatable = yes
and I recommand the option 'merge row and reduce data'

by default, all element from both table will show up in your list, but you can change that element by element and display only your 'course' information in your list and everything in your form.

 

[joshblevins]

I really do appreciate your help.... This worked great.... I did attempt to use this information to do the similar thing to another list/form. However the add or delete button are not showing

Link Here

http://www.emstrainonline.com/2012-10-17-03-32-56/2012-10-19-21-02-51/patient-care-report/form/6/0

Not sure what I did wrong I believe settings are the same

Here is the link to the form you helped me fix

http://www.emstrainonline.com/my-courses-2/courses-offered/form/3/5

 

[joshblevins]

Also is there a way to rename the tab so it displays the label and not he element name

 

[joshblevins]

All problems seem to solved in this thread at this time...... Thank you so much for your help..... It seems I just needed to change a few settings.

 

[Fred04]

I'm glad it help you
By the way, your form looks good. This is the power of Fabrik!