I really love HomeManage. I converted from long time use of WhatYouOwn Inventory tool and the reporting features in HomeManage are outstanding! I use the tool to not only track our home inventory, but I have an extensive model railroad collection and I use this tool to catalog all of the engines, cars, structures, etc.. I used the Attachments option to capture all of the PDF documents and most of the pictures. I did not want to load all of the pictures into the Assets table.
I would like to create a report that lists the attachment Path(s) associated with an asset.
I did not see any template and the custom reporting tool does not see the foreign key relationship between the Attachments table and the Assets table.
I am happy to create a custom report but the ParentID in Attachments is not visible in the columns available and the ID (homeManage ID) field in the Assets table is not visible so I can not create any sub-report filtering.
Is it possible to update the Combit data source so that the relationship between Attachments and Asset tables are shown? Similar to the way Asset and NotebookItem are displayed.
I've attached a picture of Select Data Source options in the "Create A Report" tool I was using as reference
Thank you for your help,