AnsweredAssumed Answered

Value list problem

Question asked by john9210 on Mar 7, 2014
Latest reply on Mar 7, 2014 by philmodjunk


Value list problem


     FM 12 Adv.

     I have two related tables: Organizations and Specialists. On an Organization table layout I would like to use a value list on the field Organizations::fkSpecialistID that inserts Specialists::pkRecordID into the field but displays values from a second field Specialists::Name. Every time I try to set this up I get the message that the value list cannot use the field because it is not indexed.