Value Lists generated from multiple fields

[MsqedMan]

Hello List,

I am trying to make value lists specific to a certain field. ie, in DB #1, I have Receiver #, and 16 fields for the frequencies programmed into the receiver. In another DB, I want to have the Receiver # field be a pop up list only showing the numbers from "Receiver #" in the first database, and a "Frequency in Use" pop up list consisting of the 16 fields of frequencies from DB #1 related to the Receiver #. Does this make sense?

I am in every way a beginner at FMP, but am quickly becoming addicted to it!

TIA,

Tony

[cjaeger]

show value list from field, related ony,frequencies::freqlist

freqlist is a calc field in the frequencies db

= freq01 & "q|" & freq02 & "q|" & ... &.freq16

("q|" is the filemaker return char)

[MsqedMan]

Christian,

Thank you for the help. I made the field freqlist, and I can now get "all" frequencies to show up on a pop up list in the second DB, but I can't figure out how to only show the freqlist for receiver 1, the freqlist for receiver 2, and so on. I guess I need to read up on how to relate the freqlist value list to the receiver number? Or am I going about that wrong?

Thank you again!

Tony