highlight entire row?

[jonr]

In a table view, the current record is indicated by a narrow band at the left. Is there a simple way to arrange that the entire row be highlighted (as in Excel, when you click on the row number)? I know you can put a button over the row, and you get a highlight effect when you press the button, but that's not sufficient. I'd like that same visual effect, but automatically for the current record, without requiring any user action.

[Mandu]

I know how to do it for List view...

Add an auto-enter number field ("record_id") to the record, and have the auto-enter be the calculation Get(RecordID). This exposes each record's unique, Filemaker-assigned i.d. number. (If you already have some records in your table you should either reload them, or do a Replace Field Contents on your new record_id field to initialize them properly).

Add a global number ("g_current_record_id") and use Set Field to set it to Get(RecordID) prior to displaying the list.

Add a global container ("g_highlight_swatch"), and insert into it a graphic of the color you want to highlight with.

Add a calculated container field ("c_highlight") whose calculation is:

If ( record_id = uc_current_record_id ) ; c_highlight_swatch )

Place c_highlight on the row layout, and be sure to set its Format>Graphic to: "reduce or enlarge", "do not maintain original proportions", and "center / center".

The thing that's less than perfect about this is that you have to have a script set g_current_record_id everytime the current record changes. Most likely someone else on the list has a better solution.

And it occurs to me that this only works in List view, where you have the ability to place one field atop another to achieve highlighting. You don't have that in Table view.