Jump to content

Ice Lantern

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ice Lantern

  • Rank
  1. Ender, Yes, that is exactly what I'm looking to do. I want to be able to search through all of the records to make sure that a duplicate entry of a teacher and event combination is not already there and then prevent the user from choosing that event. FileMaker Version: 5 Platform: Mac OS 9
  2. Hi Everyone, I'm working on a many-to-many relational database and I'm having trouble writing a script. There are 3 databases: Teachers, Events, and EventTeach (join file). I can add events to teachers and vice versa fine, but I want the Add Event script to check to see if that teacher already has a specific event associated with them so that duplicates events don't get added to one teacher. I don't know how to go about doing this. I was thinking about how to script current field info and then checking if it already exists as a record. Any help would be great. Thanks. FileMaker Version: 5 Platform: Mac OS 9 Many to Many.zip
  3. Thank you ESpringer for your help. I did just as you said and the databases are working the way that I wanted them too.
  4. Hi, This is my first post and I'm a newbie with File Maker Pro. I've been working on a relational database between Teachers, Faculty, Staff and Events that they have attended. So, I want the Events DB to list all of the Teachers, Faculty, etc that have attended each event. Vice versa, I'd like the Teacher, Faculty, etc DBs to list the events that each person attended. What I'm having trouble with is adding and deleting people and events. For example, if I add a teacher to the Teacher DB with a NEW event, I want that event to be added to the Events DB and if I'm in the Events DB, I want to add a teacher to the list and have a new record pop up in the Teachers DB. Also, if I remove a teacher from a list, I don't want that teacher deleted from the Teachers DB. I'm attaching a zip file with clones of the Events and Teacher databases. I would really appreciate the help. Thank you. Relationship Trouble.zip
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.