I have 2 files: a Member file and a Course file.
I also have a third file: Member_course, to match MemberID and CourseID in the two files.
I've made a layout for my course file where I register a new course, and there is also a portal showing all the members that have joined the course.
I have also added a field (popUp-list) connected to a ValueList. This valuelist is SUPPOSED TO only contain members who HAVE NOT joined the course yet (I have only managed to make it contain ALL members, but that is not very user friendly).
By selecting a member from the list, and then clicking my "Add member to course"-button, I add a new record in the Member_course-file.... BUT: How can I strip down my valueList so that it only contains members that have NOT joined the current course? When I add a member to the course, I want that member to immediately disappear from the popUp-list/valueList.
Another question: My Member_course-file has the following fields: MemberID and CourseID, and it should not be possible to add two identical records (I thought I would find a way to define a compound primary key for my file, but it seems to me like there is no primary key in FileMaker? How do I solve this?
thanks for your help
shmokk
