AnsweredAssumed Answered

Multiple Drop Downs via Same Value List / Related Field

Question asked by SeanKooner on Jul 10, 2014
Latest reply on Jul 18, 2014 by philmodjunk

Title

Multiple Drop Downs via Same Value List / Related Field

Post

     Hello,

     Somewhat of a beginner to Filemaker but picking it up rather quick. I've finally ran into a wall though. I'm sure I could figure it out with more trial and error but I thought I'd seek help.

Table One
     - ltype
     - lcost

Table Two
     - ltype1
     - lcost1
     - ltype2
     - lcost2
     - ltype3
     - cost3


     Basically creating 3 pop-up menus on the Table Two layout (ltype1, ltype2, ltype3) with value lists that refer back to "Table One :: ltype" .

     Now attempting to fill in lcost1, lcost2, lcost3 with the corresponder value from Table One depending on ltype1, ltype2, ltype3.

     I have no problem getting this working if there was just one instance, but there seems to be conflict when doing it three times. Am I missing something? What kind of relationship should I be using?

     Please let me know if I'm missing any further information.

      

     Thanks!

      

Outcomes