using MySQL fields
I posted a couple of days ago but haven't heard anything, so I thought I'd try again!
I am using FM 11. I have a shadow table in my database and I am using one of those fields in one of my layouts. I need to use this same field in a portal on another layout in the form of a drop down list (I want to use it as the value list for the drop down). This does not work because the external field cannot be indexed. I created a calculation field where it equals the field from the shadow table. This also does not work. Is there a way to do this?