I'm trying to fashion what I thought would be a simple construct:

I need to provide the user with a popup showing up to five numbers for a particular "region" and have them select a "current value" for the region. The five values are held in a repeating field within each region's database record. The values are editable by a supervisor and might change day-to-day for any region.

In the example below, I defined a global record as a reference to the current region, but no combination of settings has worked for me so far. I either get no values or a list of all values across all records. A search of this forum turned up a similiar question from last month from Mariano but there were no responses.

Any help will be appreciated.

Pop.fp7.ZIP

Well, I have no idea what this is supposed to do, but try it anyway.

Pop.fp7.zip

Thanks, comment.

You got the result I was looking for. I just don't follow the approach (of adding the List 3 table). I deleted my List 2 table and everything still works.

Can you ... comment?

See the definition of the value list - I believe it tells the whole story.

So "List 3" is a Table Occurrence that exists solely for the purpose of looking back at the particular current record from its related table (via "include only ... values from Lists"). Is that basically it?

I'd say List 3 is a Table Occurrence that exists solely for the purpose of relating a record to itself, and only to itself. So "related values" are the values from the same record, and only the values from the same record.

That's the "distilled" explanation I was seeking. With so many clever and powerful features available in FMP, I wasn't thinking such a construct (TO) would be needed.

Thanks very much for getting me on the right track with this.