1. Is there any way to create a drop down menu that, when a value is selected, another value is generated in another field. For example, selecting "breast" in a drop-down which would generate an ICD code in another field.
2. Has there been a request to add a feature that allows attaching of scanned documents or images to an individual or a pedigree?
Thanks for your post Kisha!
1. You can create a computed field that would take the value from the drop-down menu and then display an ICD9 code if that value is present. If your drop-down menu is in a table, then your computed field would also need to be in that table.
2. You can create an image field in Progeny to handle the scanned images. Go to the Fields section to create the field and select the field type 'Image'. Then you can click in the image field on the datasheet, select the image that you want to appear and then click outside of the field box. The image will then appear for you on the datasheet.
1) We have also used lookup tables to do something like what you describe in #1. I think that might work perfectly for ICD9 codes since there are so many and you can import the list of how they match up to the value you select.
2) When we have used the image field for documents or images it can be kind of tricky because if you adjust the size of the field it can distort the image and you don't always have the best dimensions or quality of the picture. We have started using the hyperlink field and linking to a folder location that contains files like images or scanned documents for that subject. That works well unless the path of the file changes (also a problem for the image field) since the image and documents are not actually stored in the db, just the path to where they are saved.
You must log in to post.
RSS feed for this topic
