How do I "freeze" a column

[ecasleen]

Is there anyway that I can freeze a column like in Excel in a filemaker database? I have a DB with names that are the first Field column and I want to freeze the pane so when I scroll waaaay over to the right they'll travel with me

[RalphL]

You can simulate this using related fields and a relationship for each column. Make your layout no wider than your screen width. Determin number of columns. Set up a global field which will be the key field for the first data column to be displayed. Set up calculated fields to be key fields for the remaining columns, i.e., if the increment in the key is 1 then the next field is the global + 1. You need scripts to navigate left and right. The scripts set the value of the global. When run it gives the appearance of scrolling. You can have buttons that scroll one column, one page or to the begining or end.

[ecasleen]

Thanks Ralph!

[RalphL]

Let me know if you need help with this.

[pgranpre]

Hi Ralph,

I'm really interrested in the technique you describe.

Could you please send a small database example using this technique ?

Thank you very much for your help,

Pascal

[bcooney]

The original date on this is 2004! Don't expect an answer. BTW, if you need this, imho, stay in Excel.