Hello All:

I am trying to create a table view of my records, and want the first
column fields to be clickable.

When the user clicks a record's field in the first column, a
transparent button would run a script and show the details of this
record with a diiferent layout.

I want clicking on fields on other colums to give me a subset of the
records that contain the same values.

There is an example in a different DB that I can access as a user
only. I therefore cannot look at the underlying structure. Perusing
through the manual for layouts, table views, etc., I did not come
across any examples or suggestions.

Thanks

Sam

"SamMc" <FMP_account [at] hotmail.com> wrote in message
news:1185918943.208710.247000 [at] i38g2000prf.googlegroups.com.. .
> Hello All:
>
> I am trying to create a table view of my records, and want the first
> column fields to be clickable.
>
> When the user clicks a record's field in the first column, a
> transparent button would run a script and show the details of this
> record with a diiferent layout.
>
> I want clicking on fields on other colums to give me a subset of the
> records that contain the same values.
>
> There is an example in a different DB that I can access as a user
> only. I therefore cannot look at the underlying structure. Perusing
> through the manual for layouts, table views, etc., I did not come
> across any examples or suggestions.
>
> Thanks
>
> Sam
>

table views are not gonna allow that... HOWEVER, you can create a list view
that looks similar and then script the fields. You can put buttons and
look-up fields in the header of a table view and do some net things.

Another approach is to use a self portal and script the fields as buttons.

In article <1185918943.208710.247000 [at] i38g2000prf.googlegroups.com>,
SamMc <FMP_account [at] hotmail.com> wrote:

> Hello All:
>
> I am trying to create a table view of my records, and want the first
> column fields to be clickable.
>
> When the user clicks a record's field in the first column, a
> transparent button would run a script and show the details of this
> record with a diiferent layout.
>
> I want clicking on fields on other colums to give me a subset of the
> records that contain the same values.
>
> There is an example in a different DB that I can access as a user
> only. I therefore cannot look at the underlying structure. Perusing
> through the manual for layouts, table views, etc., I did not come
> across any examples or suggestions.

You can define the fields themselves to be buttons, so you don't need
to use an actual transparent button over the top.


The first one (first column field) is quite easy. The button simply
needs to use the "Go To Related Record" script / button command.

I'm not quite sure how the newer versions of FileMaker handle a
different Layout now that tables can all be in the one file, but the
older method should still work ...
eg.
Go To Related Record []
Go To Layout ["Detail Layout"]

as long as the Detail Layout uses the appropriate table.


The second one (other column fields) is perhaps easiest done by
scripting a Find, but it depends on how you want that subset of records
to be displayed and whether it's the Parent or the Related records
you're looking for. For example, if the user clicks on a "Food" field,
then the script might be something like:

Set Field [g_FindOption, Relationship::Food]
Go To Layout [DisplaySubset]
Enter Find Mode []
Set Field [Food, g_FindOption] **
Perform Find []

where the DisplaySubset Layout uses the appropriate Table.

If you're looking for Parent records, then the line marked ** above
would need to be performed on the Related field.
ie
Set Field [Relationship::Food, g_FindOption]

Instead of the Global field g_FindOption you can use parameters in
newer versions of FileMaker.

You would need a separate script for each of the original fields from
the Portal columns since it has to perform the Find using different
fields ... although you could get around that by using a Calculation
field to combine all the column fields into one searchable field.



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