Our WP blog makes use of both the WP CMS, and some custom CMS pages written outside of WP. The custom CMS pages store their data in dedicated tables the WP database.
What we are looking for is the ability to display values that were defined in our custom CMS pages, within the WordPress CMS.
For example, currently WP has a "custom field" system whereby you can create new custom fields (or select existing custom fields from a dropdown) and assign a value to each custom field in the textarea to the right of the custom field.
What we want is to display a line in the WP CMS that reads: "Use this testimonial on this Page": and to the right, have a dropdown list of all the testimonials the user defined in our custom CMS outside of WP. When the page is saved, WP would save the user's selected value as well.
Alternatively, if the user could enter in a WP custom field such as "use-selected-testimonial" and to the right, instead of a textarea, if a dropdown list of the existing testimonials could be displayed, that would work as well. Again, the selected value would need to be saved when the user pressed Publish or Update.
Is this something that is feasible to accomplish?