no matter what!

I can't get it to work in my existing database, so I made a new one with one table, 2 fields, and 2 records. In the first record, fields 'A' and 'B' contain the values 'A' and 'B'. IN the second record, 'A' contains 'A' and B is empty. On the layout, A is about an inch above B, in the body, and the body is 2 inches tall. B is set to sliding based on all above and 'reduce the size of the enclosing part' is checked. In preview mode, the body parts are the same size for both records.

I would have expected the body part for record 2 to reduce to the bottom of field A--the only other object on the layout.

What am I missing?

Thanks,

Dave

Oh, my favourite :-) Sliding/printing is a bugger to get working properly.

Post your file on here and I'll have a look.

James

Hi David, and welcome to the Forum.

Many times there is more than one way to do something in FileMaker. By posting a file, you will have the benefit of many of us looking at it, which can speed up the process of getting a solution to your question. The suggested solutions will also be directed at your file, fields, TOs, Scripts, Layouts, etc.., instead of being for some imaginary one, which we have had to concoct in our minds trying to figure out what you are asking.

Lee

Thanks. I have worked some of it out--the part only reduces by the amount of space the field would have taken up, which makes sense I guess.

What I really want is this: a label layout that prints a school family's second name address (in the case of divorce or separation e.g.) if there is one but reduces the size of the part by exactly one inch (one label height).

I see. To be perfectly honest I think that trying to print two labels (but sometimes one) from a single record is asking for trouble!

If that's what you're attempting to do I would abandon sliding/printing altogether.

My suggestion would be a new table called "labels". Then a script along the lines of:

go to layout 'pupils'

show all records

go to layout 'labels'

show all records

delete all records

import records [restore]

go to layout 'pupils'

perform find [restore]

go to layout 'labels'

import records [restore]

show all records

print

This will give you labels for all the 'first addresses', then labels for all the 'second addresses'.

Hope that helps. I have subscribed to this topic so if you get stuck then post another update.

James

Thanks for the quick feedback. I've posted a scaled down sample of the database. I want the 2-inch body to stay at 2 inches if there is second address data, and to collapse to 1 inch if there's not.

I currently have a workaround which separates the data into families with one address and with two, and prints on separate layouts, and maybe I have to stay that way--but maybe not!

I appreciate your welcoming community,

Dave

Oh wait, I was going to upload, but I see that .fp* is not a supported type. Is zipping it first the protocol?

Thanks

@James--responding to your response after my most recent post:

You're probably right--asking for trouble. Your solution looks workable, albeit a bit beyond anything I've done so far. OTOH, this doesn't seem like that unreasonable a desire. Surely this must come up all the time in applications that track families that may or may not share an address.

Thanks again.

To attach a file, see my description of the steps here. Link

Use the Zip format.

Lee

Thanks, Lee.

test2.zip

Perhaps this can be a work around.

test2_mod.zip

Lee-

I currently have another post in a different area of this forum--this is an extremely simplistic question--but how would I upload my fm database to this site when asking a question. I noticed 101 people viewed my previous question. So I think my logic (or lack there of) is probably a common issue. I don't mind sharing whatever I am doing if it help anyone else struggling to learn;)

Your thread is active, why would you need to split your question between this one and that one?

Private Topic me and explain why you think you need to do this.

Lee