I'm pretty sure this is a define fields question and not a layout question.

So I thought I would start here.

I'm trying to produce a set of dynamic buttons which change their titles based on changes

to the records in a different table.

I am developing a bunch of scripts for task management and I am trying to minimize button maintenance. I'm thinking about using LaRetta's concept of holding graphics in a script parameter.

If skippy is in the building (I call this the Elvis button) his face shows up and you click on it. If

he's not, you take him off the list till he shows up again.

My idea is to create individual fields and use them as buttons to call the scripts.

If you see somebody's name (or picture) you click on it and the script launches.

So far everything is pretty basic. A simple relationship and button stuck inside a portal will do this.

What I am trying to do is have the field value be linked to a specific record value (deriving from ordinal position of the record in the second table).

As I see it: Table 1 has three fields:

Worker 1

Worker 2

Worker 3

Table 2 has one field: Worker Name

Table 1: Worker 1 equals Table 2: Record 1

Table 1: Worker 2 equals Table 2: Record 2

Table 1: Worker 3 equals Table 2: Record 3

[color:"red"] Is there a way to set the value of a field in one table to be equal to the ordinal value of a specific record in a second table?

Thanks for any help (and patience),

Jarvis

Is there a way to set the value of a field in one table to be equal to the ordinal value of a specific record in a second table?

If you make the text of the button a reference to a field, as a mergefield will it change accordingly! Filtering the resulting thru-put of the ValueItems( function could make this happen...

--sd

Thanks Soren.

I will look at the mergefield concept.

Jarvis