AnsweredAssumed Answered

many to many relationships

Question asked by laneystewart on Mar 19, 2009
Latest reply on Mar 19, 2009 by laneystewart


many to many relationships


ok so I am back... just when i thought that I knew enough.....  I have a many to many relationship with students and colleges.  I have a student table and a college table with a ZID field that auto-enters a serial number when a record is created.  I have created a join table with a studentID_FK and CollegeID_Fk.  How do I get this table to make a new record when a new record for the student is created and get the studentID_fk to populate with the same number as the ZID????  The colleges in the college table will remain the same. I am looking to set up a portal with a list of the colleges in a layout drawn off of student.  I eventually want to be able to filter the list of schools in the portal as described in the special edition Using Filemaker 9 book, chapter 17.  I can get the entire list of colleges to appear in the portal by choosing the [X] in the relationship, but I do not want to have this long of a list to scroll thru.  Any help would be appreciated.  Thanks in advance!