Multiple Drop Downs via Same Value List / Related Field
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.
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.