Dropdown field in document type to populate data from custom table

Terrence Foulk asked on August 28, 2014 21:53

I created a dropdown field in a document type to select an item. But I am having issues populate additional data from the custom table based on the dropdown selection.

Can I access custom table data based on a document type field that is populated from that custom table?

Thanks Terrence

Correct Answer

Charles Matvchuk answered on August 29, 2014 04:07

Can you elaborate on exactly what you are trying to accomplish ?

I think what you are asking is that if you have a drop down list (combobox) and you store an ID in the document, in the transformation you would like to get more of the information from the row of the stored id in the custom table.

There are several approaches, I traditionally just modify the query or view and join the tables on the ID, that way the additional columns from the custom table are in the underlying data. Although if you are not using unique ID's in your custom table and storing those values in your document, then you will have an issue.

Please explain in detail what you are trying to accomplish.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Terrence Foulk answered on August 28, 2014 22:35

Can I use CustomTableItemProvider.GetItems from http://devnet.kentico.com/articles/custom-dropdowns-managed-by-the-editors-in-a-few-minutes in a transformation for this?

0 votesVote for this answer Mark as a Correct answer

Terrence Foulk answered on August 29, 2014 15:04

Thank you for responding so quickly. I was trying to delete this before anyone committed to this issue, but I didn't see how I could. It was just as simple as you stated.

When I was first thinking of this task it seemed so much more complicated. I just needed to take a moment and map out what I needed. Some days are more frantic than others!

Thanks again Terrence

0 votesVote for this answer Mark as a Correct answer