September 2, 200421 yr Newbies 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
September 2, 200421 yr 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.
June 29, 201114 yr Newbies 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
June 29, 201114 yr The original date on this is 2004! Don't expect an answer. BTW, if you need this, imho, stay in Excel.
Create an account or sign in to comment