Jump to content
Sign in to follow this  
CurlyD777

Horizontal Column Views

Recommended Posts

I am recreating a database to replace a series of excel spreadsheets. The visual views available in excel that we use numerous times to look at our tables is to have customer’s listed vertically, and jobs listed horizontally, and then show their sales numbers listed in the grid area.

We can have up to 30 or so jobs in a given layout, and excel allows you to split the screen to “freeze” the customers column while you scroll horizontally and view the numerous jobs.

Does any one know how to recreate this freeze ability in filemaker? If it’s not possible, does anyone have any good examples or solutions where you can show a customer list vertically, and then list horizontally more columns, allowing you to “freeze” the customer column while scrolling through the numerous job columns?

Any suggestions or comments would be much appreciated.

Thanks

Share this post


Link to post
Share on other sites

Check out the web viewer section on this site.

Maybe you can use google spreadsheets to show the data.

http://www.fmforums.com/forum/showtopic.php?tid/187714/

Share this post


Link to post
Share on other sites

Perhaps staying with Excel may be the answer. Or exporting to Excel with a macro for formatting.

Share this post


Link to post
Share on other sites

BC may be right depending on why you want to switch to a relational structure. Really comes down to why you want to switch.

We switched due to having a purchasing file that over a few years grew to having over 20,000 lines in it and searching for a part was hell to say the least. Find, find , find, find, find, find, find, find, find, find, find, awww crap I passed the last time we purchased it. So do it again.........Find, Find.........

My advice is to ask what you want from switching to Filemaker and then decide. Filemaker is not excel and making it look and act like excel is the wrong approach and will only hinder your end goal.

Just my 2 cents

Michael

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.