1 2 Previous Next 21 Replies Latest reply on Mar 18, 2015 7:46 AM by CarstenLevin

    Why are child records deleting even when no relationship in the TOG?

    nickg

      Using FMProAdv13 I have been converting a spaghetti relationship graph into an anchor-buoy model for a database with 25 tables and 50 or more layouts. Although tedious, all is working properly now with one exception, which I cannot fathom.

       

      I have a GPSReadings table that relates to an Observations table through a GPSUsage table that resolves the many to many relationship:

      Observations >--- GPSUsage ---< GPSReadings

       

      There is a 'delete through relationship' from Observations to GPSUsage but not from GPSUsage to GPSReadings.

       

      I would expect that when I delete a selected Observations record, the related GPSUsage records would go but the GPSReadings records would not be deleted. However, when I delete the Observations record the GPSReadings records are removed as well.

       

      Nowhere else in the relationship graph is there a layout that allows deletion of GPSReadings from GPSUsage.

       

      I have built a test database replicating the relationships and that works as I would expect.

       

      Can anyone suggest why this is happening or how I might investigate further?

       

      Nick

        1 2 Previous Next