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.
|
![]() |
Sergey Kornilov admin 7/18/2013 |
Unfortunately I wasn't able to decipher this. |
G
|
gdude66 author 7/18/2013 |
I worked it out. |