Help with FileMaker Pro 7

[mac_g4]

Hello, can anyone tell me how to make a scolling window in a layout. I have an invoice layout but all my item fields wont fit on the layout and I'd like to view them in a scrolling window rather than increase the layout size. I'm new to FileMaker but I've seen what I want to achieve in Sage software. Thanks very much.[color:black]

[Matthew F]

As you're probably aware you can add a scrollbar to a field using "Field Format...". You can make a layout part as large as you want and then a scrollbar will appear on your window in order to view the whole thing.

I think what you're looking for is a scrollbar on a layout part (e.g. the layout Body) but that's not a built in feature of FMPro.

[mac_g4]

Thanks for the reply, I'm amazed that what I'm after is not possible in FM. It seems such an elementry feature. Do you know of a plug-in etc. that can enable the scrolling window in a table area. thanks again.

[LaRetta]

make a scolling window in a layout. I have an invoice layout ... to view them in a scrolling window rather than increase the layout size.

Your request appears contradictory but I envision you might mean something like a split screen? Invoice body with portal of LineItems ... but you want only the top (Invoice fields) to all 'scroll down' to display additional Invoice fields while the LineItems stay in view? Because otherwise you can drag your Body tab downwards. Your PM prompted my response; I'm currently in the middle of a heavy project and normally wouldn't have responded until/unless I could test my ideas.

If you wish for a split screen effect, it seems quite possible (but I've never done it). Create another table occurrence of thisTable (self-join in graph). Join thisTable::UniqueID = Self-Join::UniqueID. Place self-join portal (only one row) stretched to the size of your upper portion. Be sure to double-click all existing Invoice fields and re-specify field to selfjoin::theField before placing them within the portal. Turn on portal scroll.

There may be some hidden problems which I wouldn't know about without testing however, so TEST, TEST, TEST! Example: if you use this layout to script New Record (or various other things), I would review all scripts which fire on this layout before implementing it. You may need to Commit to popuplate the portal on New Record or (in other ways) tweak your scripts. And you would want different views for printing. But in theory, it should work just fine.

Update: WHOA! You slid a post in! Table area? You have little control over tables. What I've described should work on Form view (and maybe even List view??). However you CAN use Header to hold global but ...

Tell us what you have specifically. What type of layout and what's on it and what do your Users do?!! :

LaRetta

[SlimJim]

In List mode the header and footer stay fixed while the body scrolls. The scroll bar is not in the body part but the body part is the only bit that moves when you use the scroll bar.

EDIT I should add that the main intent of this is to scroll through records but if you have only one record in your found set it scrolls through the body

Edited August 7, 2005 by Guest

[mac_g4]

Ok everybody, thanks for the replys. I'll try all the solutions and see what happens. I don't seem to have explained myself very clearly so if I get stuck I'll post a clone of my DB on here so everyone can see what I'm talking about. Thanks for now.