We are creating a new application for a police department to track Crime Reports. The reports have several sections Administrative, Offense, Victim, Offender, Property, and Narrative. We want to start with the administrative section of the report and attach the related offenses, victims, offenders, property, and narrative to the Administrative section using the case number as the key. We want the case number to be inserted and saved into the related sections as they are created. If the Administrative section of a report is deleted we want each record associated with the report deleted. We are new to Filemaker Pro. How do we relate and insert the case numbers into other section as they are created?

In your administrative file you can have portals to all the other files. Set the relationship definitions to

"Allow creation of related records", and

"When deleting a record in this file, delete the related records"

Then, if you do the creation in the portals, the case number will be inserted automatically. And, when you delete the record in the administrative file, related records will also be deleted.