I'm trying to set up proper relationships.
Student – common table for all three groups (with id, names, dates of births etc).
Former – extension of Student table, but only for former students who has resigned (with info about cause of leaving)
Graduate – extension of Student table, but only for graduates (diplomaNumber, ifPassedExam, etc.)
Present – extension of Student table but only for present students
It looks like those ralationships should be one-to-one.
Now it's my question: how should i link them?
Student –––– Former
Student::id = Former::id AND
Student::status = Former::key_FORMERSTATUS
Students::status is text field (controlled by pop-up menu with value list of status)
Former::key_FORMERSTATUS (is global text field (pop-up menu with value list of status) – as all the records in Former table should concern former students)
When I have tried that, first it looked fine. But when I changed value (for testing) in Former::key_FORMERSTATUS to graduate, on layout based on Student i can see info in related fields from Former table (lookse like second parameter of relationship is not working). But when I put portal on Former layout I see no related records.
Any help will be appreciated.