Hi Fiona, we use descriptive attributes here at Cube for location and tenancy (at least some of them) but from what I can understand from your mail I doubt it would be a useful way to itemise furniture or track useage / replacement. I would suggest an MS Access or SQL database for this that you can perhaps tie into your housing reporting by incorporating it into an Open Query report. If you are not using OPen Query, another way would be to compile a spreadheet that has your furniture assets but pulls out tenancy / property changes from your IBS database through a linked table query in Excel. For this last one you will need the Progress ODBC drivers linked to your IBS database instance(s). If this helps let me know and I can dig out some instructions on how to do this. Matt Cowan CUbe Housing Assoc. ________________________________ From: sibsug-bounce@xxxxxxxxxxxxx [mailto:sibsug-bounce@xxxxxxxxxxxxx] On Behalf Of Fiona Ross Sent: 01 July 2009 16:14 To: sibsug@xxxxxxxxxxxxx Cc: Lorraine McKechnie Subject: [sibsug] Using descriptive attributes Hi All, We are looking at the best place on IBS to record furniture that we provide tenants and replacement furniture and wondered if "descriptive attributes" is the best place. Does anyone else: * use this facility; * if so are there any pitfalls that we should look out for; * recommend any other part of IBS where this info may be best recorded. Regards Fiona Ross Housing Services Co-ordinator Ark Housing Association Ltd Tel: 0131 478 8160 www.arkha.org.uk <http://www.arkha.org.uk/> Scottish Charity No. SCO15694 P Consider the environment. Please don't print this e-mail unless you really need to. ________________________________ Disclaimer ARK Housing Association Ltd This message, together with any attachments, is sent subject to the following statements: 1. It is sent in confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentially and to advise the sender immediately. 2. It does not constitute a representation which is legally binding on the Association or which is capable of constituting a contract and may not be founded upon in any proceedings following hereon unless specifically indicated otherwise. This footnote also confirms that this email message has been swept for the presence of computer viruses. ARK Housing Association Ltd is a Scottish company registered at The Priory, Canaan Lane, Edinburgh, EH10 4SG. Scottish Charity No. SCO15694 www.arkha.org.uk Tel: +44 (0)131 447 9027 Fax: +44 (0)131 478 8173 ________________________________ Matt Cowan ******************************************************************* This e-mail is confidential and its contents may be privileged. It may be read, copied and used only by the intended recipient(s). If you have received it in error, please contact the sender immediately by return e-mail. Please then delete the e-mail and do not forward nor disclose its contents to any other person. We believe, but do not warrant, that this e-mail and any attachments are virus free. Views expressed in this e-mail are of the sender and may not reflect the views of Cube Housing Association. Cube Housing Association Ltd. is; a registered Scottish charity under the Law Reform (Misc. Provisions)(Scotland) Act 1990 as SC033021, registered by the Financial Services Authority under the Industrial and Provident Societies Act 1965 as 2327R(S), registered by the Scottish Housing Regulator under the Housing (Scotland) Act 2001 as HAL220. Registered Office: 45 Finnieston Street, Glasgow, G3 8JU !! Think about the environment - only print this email if you really need to !! *******************************************************************