https://legacy.forums.gravityhelp.com/topic/how-can-i-get-this-done Gravity Support Forums Topic: How can I get this done en-US Tue, 21 Apr 2026 04:43:18 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/how-can-i-get-this-done#post-80760 Sat, 13 Oct 2012 10:17:44 +0000 sadiq.emeran 80760@https://legacy.forums.gravityhelp.com/ <p>My suggestion is for him to have 3 Tables, one for [Owners] to store Owner Info, one for [Dogs] to store Dog info &amp; another for [DogOwners] which will be to track which Dog belongs to which Owner.</p> <p>When a owner creates his profile his data goes into the [Owners] table &amp; the Dog seperately into the [Dogs] table.<br /> I would like to use gravity forms.</p> <p>At the same time a record is inserted in the [DogOwners] table with the matching OwnerID &amp; DogID paired together with a boolean field to say if its active or not.</p> <p>Then when a transfer is made between 2 existing Owners, so the one with the existing [DogOwners] record gets his record updated &amp; the boolean field set to false. A new record will also need to be inserted into the [DogOwner] table for the new OwnerID &amp; the same DogID with the boolean set to True.</p> <p>Thanks </p>