Values from second field in Value List

Suppose I have a database with 3 tables: Octagon, Points, and
Segments. Inside the octagon, there are obviously points and
segments; and a point can belong to many segments and a segment can
have many points. Each segment has its own unique id and a name; same
for the point.

Let's say I want to add a 4th table named Octagon_Inspections (that is
tied to Octagon) so I can check to make sure that everything is okay
with each segment and so forth. On each inspection, they can choose
any or all segments.

So I have a layout for the Octagon_Inspections table. After you
choose which octagon you want to edit, there is a second (checkbox)
field asking you which segment(s) you want to edit. It is
conditionally based on the relationship of octagon to points. So as
you change Octagons, the Segment names in the checkbox change as well.

If a user chooses 3 of the 8 segments, say 1 (Red Segment), 5 (Blue
Segment), and 6 (Green Segment), where the numbers are their unique
ids, the box (in a regular text field) would look something like this:

1
5
6

although to the user it looks like this:

x Red Segment
Yellow Segment
Purple Segment
Black Segment
x Blue Segment
x Green Segment
White Segment
Orange Segment


The twist:

I want to add a 5th table to track any issues that arise in an
inspection. In my layout I add a portal. The portal has the
following fields: Segment and Issue.

I want the segment field to be a popup field with its values based on
the checkbox field numbers (the segments the user wants to inspect) .
I got that far. So when a user clicks on the "segment" box in the
portal, the following list comes up:

1
5
6

However, I want the list to say:

Red Segment
Blue Segment
Green Segment

Any way to get the names of the segments to somhow tie to another
instance of the Segments Table so that the list looks like I want it
to?

thanks in advance,

Eric

Re: Values from second field in Value List

In article
<40cbae6a-6430-41e3-b6d1-b20d13963c05@v46g2000hsv.googlegroups.com>, EP
wrote:

> Suppose I have a database with 3 tables: Octagon, Points, and
> Segments. Inside the octagon, there are obviously points and
> segments; and a point can belong to many segments and a segment can
> have many points. Each segment has its own unique id and a name; same
> for the point.
>
> Let's say I want to add a 4th table named Octagon_Inspections (that is
> tied to Octagon) so I can check to make sure that everything is okay
> with each segment and so forth. On each inspection, they can choose
> any or all segments.
>
> So I have a layout for the Octagon_Inspections table. After you
> choose which octagon you want to edit, there is a second (checkbox)
> field asking you which segment(s) you want to edit. It is
> conditionally based on the relationship of octagon to points. So as
> you change Octagons, the Segment names in the checkbox change as well.
>
> If a user chooses 3 of the 8 segments, say 1 (Red Segment), 5 (Blue
> Segment), and 6 (Green Segment), where the numbers are their unique
> ids, the box (in a regular text field) would look something like this:
>
> 1
> 5
> 6
>
> although to the user it looks like this:
>
> x Red Segment
> Yellow Segment
> Purple Segment
> Black Segment
> x Blue Segment
> x Green Segment
> White Segment
> Orange Segment
>
>
> The twist:
>
> I want to add a 5th table to track any issues that arise in an
> inspection. In my layout I add a portal. The portal has the
> following fields: Segment and Issue.
>
> I want the segment field to be a popup field with its values based on
> the checkbox field numbers (the segments the user wants to inspect) .
> I got that far. So when a user clicks on the "segment" box in the
> portal, the following list comes up:
>
> 1
> 5
> 6
>
> However, I want the list to say:
>
> Red Segment
> Blue Segment
> Green Segment
>
> Any way to get the names of the segments to somhow tie to another
> instance of the Segments Table so that the list looks like I want it
> to?
>
> thanks in advance,
>
> Eric

You would either have to use a field that contains those text values
(ie. replace the 1, 2, 3 field in the Portal with the "red, blue,
green" field),
OR
define a Value List that combines the two sources of the Data so that
the field displays as:

1. Red
2. Blue
3. Green

In the Define Value List window, the "from field" option lets you
specify two fields that can be used.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)