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!