AnsweredAssumed Answered

using MySQL fields

Question asked by ShelleyM on Jan 11, 2012
Latest reply on Jan 11, 2012 by philmodjunk


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?