topic One to Many HubDB Relationships in CMS Development

topic One to Many HubDB Relationships in CMS Development https://community.hubspot.com/t5/CMS-Development/One-to-Many-HubDB-Relationships/m-p/570294#M27220 I am new to Hubspot, and just figuring things out with regard to how to technically manage my data in HubDB and Hubl to do what I want.  I have played with this for a while, and done quite a bit of searching, but somewhere along the line I seem to be missing how to accomplish this. I am trying to identify how to both create a one to many relationship in HubDB and how to use Hubl to extract that data visually.  Here is what I am trying to do.  We have a horse rescue where we take in horses, then rehabilitate and retrain them and subsequently rehome them.  As a part of advertising them for adoption, we post a gallery of videos and photos, along with their bio data.  Additionally, periodically we have a horse that has been adopted out, returned, maybe because the adopter can no longer afford to keep the horse. In a traditional relationsl DB, I would set this up as a table of Horses where I have thier statistics (breed, gender, height, bio, etc) then a table of Horse Vidoes where I would add new videos of horses as we make them.  This table would just have the name of the horse in the video and the video.  A similar table for Horse Photos with just horse name and photo.  Finally a Horse Adoption table where each adoption is stored for all horses and a colum with the horses name, adoptor information, date of adoption, etc.  This table will also store data on when a horse is returned and the reason. Then when I want to display the data on a horse, I would go to the Horse table as my base table, plus pull up the multiple photos and videos of the horse from the linked tables of Horse Photos and Horse Videos, based on the many rows that match the horses name.  Finally, add in the adoption information of the horse, out of the Horse Adoption table that would show history of when adopted and when returned, and then when re-adopted out by someone else. I have worked out how to do a one to one relationship and render that data, but somehow am missing how to do a one to many.  I know I could just pull up the child table, and do a filter based on the horse name in the Horses table, then build a loop to pull all associated records, but it seems that there should be an internal wey to actually link these tables and render the data via a function or dot notation, and I am just not seeing it clearly documented anywhere. I have also thought about creating the horses as a custom object as well, but it appears as though that is not an option, as I have a Professional account, and it appears that is only an option with an Enterprise account. Any assistance that you can provide me with how to configure this would be GREATLY appreciated!! Sun, 06 Feb 2022 16:33:06 GMT RKnott 2022-02-06T16:33:06Z