Jump to content

Question Attachment table reporting

Robert B

Recommended Posts

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,
Great product
Robert B



Link to comment
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...