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?


      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?



        1 2 Previous Next