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.