This topic is locked
[SOLVED]

 Help with view format

7/16/2013 8:54:20 AM
PHPRunner General questions
G
gdude66 author

Hi

Just wondering if someone can help me structure some master detail relationships and sort out owner fields.
I have a db with the following tables and fields
Staff table

username (primary key), fn, sn, ttcode (timetable code)
Student table

idstudent, fn, sn, year
tt

ttid, classid, teacherid
ttstudent

ttid, classid, studentid
basically the studentid in tt and idstudent in student table are the same

staff ttcode and tt teacherid are the same

classid is same in both tt and ttstudent
I wanted a staff user to log in (with their username as session variable and owner field) then a menu item called my classes to come up which is a list of the staff member's classes and only that members classes and then click on one of the classes and a student list of those students in that class come up in a table and then I can add other fields form the student table.
I am getting a bit lost with it - sometimes the classes come up and sometimes the men link doesn't show.

If I can get some pointers on joiners and linked fields and which tables to start with that would be much appreciated. It is the missing link from my project.
I hope I have described this OK.

G
gdude66 author 7/17/2013



Hi

Just wondering if someone can help me structure some master detail relationships and sort out owner fields.
I have a db with the following tables and fields
Staff table

username (primary key), fn, sn, ttcode (timetable code)
Student table

idstudent, fn, sn, year
tt

ttid, classid, teacherid
ttstudent

ttid, classid, studentid
basically the studentid in tt and idstudent in student table are the same

staff ttcode and tt teacherid are the same

classid is same in both tt and ttstudent
I wanted a staff user to log in (with their username as session variable and owner field) then a menu item called my classes to come up which is a list of the staff member's classes and only that members classes and then click on one of the classes and a student list of those students in that class come up in a table and then I can add other fields form the student table.
I am getting a bit lost with it - sometimes the classes come up and sometimes the men link doesn't show.

If I can get some pointers on joiners and linked fields and which tables to start with that would be much appreciated. It is the missing link from my project.
I hope I have described this OK.


Any suggestions? I am really stuck with this.

Sergey Kornilov admin 7/18/2013

Unfortunately I wasn't able to decipher this.
I you have a valid support contract feel free to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Someone will be glad to assist you with this.

G
gdude66 author 7/18/2013

I worked it out.