PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

How can I get this done

  1. sadiq.emeran
    Member

    My suggestion is for him to have 3 Tables, one for [Owners] to store Owner Info, one for [Dogs] to store Dog info & another for [DogOwners] which will be to track which Dog belongs to which Owner.

    When a owner creates his profile his data goes into the [Owners] table & the Dog seperately into the [Dogs] table.
    I would like to use gravity forms.

    At the same time a record is inserted in the [DogOwners] table with the matching OwnerID & DogID paired together with a boolean field to say if its active or not.

    Then when a transfer is made between 2 existing Owners, so the one with the existing [DogOwners] record gets his record updated & the boolean field set to false. A new record will also need to be inserted into the [DogOwner] table for the new OwnerID & the same DogID with the boolean set to True.

    Thanks

    Posted 11 years ago on Saturday October 13, 2012 | Permalink