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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    enstorms 
×

Important Information

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