RogerJ

Why do you need the 2nd set of ",". If you leave it off, it should only show the one "," Roger in Midland, Tx

Thanks for the clarification Lee. It helps. RogerJ

Thanks for the info. Do not have a developer or "Advanced" version of FMP, but am considering it. RJ

Is it possible to create an executable from a FMP db? Is there a run time version of FMP? Thanks, Roger in Midland, Tx

Hi LaRetta; "I'm more interested in resource-use with multiple windows within FM (or is the principle exactly the same?)." Yes, the principal is the same. An open window takes up more resources than a closed or minimized window. It not only takes up SYSEM resources but VIDEO RAM, as it has to disply on the monitor. If you have a video card with lots or RAM, this will not be a problem (of course depending on how many "daughter" windows you have open), but one with limited video RAM, or a PC that "shares" RAM from the system resources could be a problem. Use your descretion...

Well, I got part of it figured out. I can now print labels without all the blank spaces. However, since I have 4 label layouts, is there a way to combine them into one with a script? Thanks,

Lee, I have (as previously stated) 39 records (of 120+) with 74 referrals. The label layout is leaving blank labels where there is no data. As an example: If record 1 has only 1 referral and record 2 has two, in label layout 1 (for the 1st set of addresses), it will have labels 1 and 2 with information. But, on label layout 2 (for the second set of addresses), label 1 with be blank, but label 2 will have the address. This is because the 1st record only has 1 referral address. To complicate this, there are 4 possible referral addresses. I have considered putting all the referrals on their own layout, but I was told they needed to be kept WITH the person submitting them. Any other ideas?

Hi LaRetta. I will briefly try and answer one or two of your questions without going into great detail. Question 1) Yes; Question 2) Yes, it affects system resources. System resources are made up of RAM and Windows Caching (a portion of the HD set aside for holding files/info when RAM is depeleted). An open app takes up more resources than a minimized app. And, it does not use video RAM for this purpose. Video RAM is only used to digest and put on the display what you see. Roger (PC TECH)

No Lee, I cannot attach the files. Because of information in the files which is private, I cannot attach or send them. Sorry. I followed your instructions -- "Layout, Select Fields, Menu, Format Sliding/Printing, Select Option". I tried all possibilities or choices but none removed the blank labels. Don't want to remove blank spaces IN the labels, but the blank labels. Make sense? Let me try again... In looking at the layout in preview mode I have 30 labels 10 down by 3 across. If they are numbered across with 1 in the upper left corner and 30 in the lower right, I have label position 1 through 11 empty, an address in pos 12, pos 13 -16 empty, an address in 17, then 18-24 empty, an address in 25 and 26 through 30 empty. So there are 3 labels. Is it possible to remove empty lables 1-11, 13-16, 18 - 24 and 26-30 on this sheet. This is label layout 4. I have 2 other layouts that have basically the same thing with varying amounts of addresses and blank spaces. Is it possible to remove all the blank labels in these layouts, then cocantenate them into 1 layout so I don't waste labels? Is that clearer? Sorry for the confusion.

Thanks for the response on both messages Lee. I did not intend this to be a double post, although I will agree that the 1) above is basically the same as my other message. However, 2) is totally different and was not addressed. I thought they were different enough to warrant a seperate message instead of including them as one. Guess I will know next time to include ALL problems in one message. If I did not make it clear what I am trying or want to do, let me know and I will try to rephrase it.

I have created label layouts from a found set of referrals. The membership form can have up to 4 referrals. I have 4 label layouts, but not all membership forms have 4 referrals (Clear so far?) For those that have only 1 referrals, the label layout works fine. But, if the referrals are >1 then the label layouts have blank spaces in them. What I would like to do is to: 1) remove all blank spaces from label layouts 2 thru 4 2) cocantenate the 4 label layouts into one (if possible) 3) print the labels Currently there are 39 records in the found set, with 74 referrals. Most have only 1, a few have 2, a few have 3 and only a couple have 4. Any suggestions as to how to accomplish this with a script would be helpful. TIA

I have a membership database that includes fields for up to 4 referrals. At one time it was a repetition field, but have since changed it to 4 seperate address fields (refName 1-4, etc.) Now, I have created a Referral layout that lists all the Referrals, but it has blank spaces which I would like to remove. If a member has only a referral (<4) the layout has spaces for all 4 of the addresses, creating blank spots in "preview". I would like to get rid of them if possible using a script. But, am a little leary of "deleting" if the field is blank. If I "find" and "remove/delete/don't show" (whatever the language) is it going to remove the field in the "found" set? In other words, I do a "find" of all records that contain referrals, then go to the layout that shows just the referrals, then find the blanks and delete them, will it delete the fields in the "found set"? Hope I made this clear. Also have another problem, see second message. TIA for your assistance.

Right, I understand about the label layouts. Since I will have up to 4 fields (basically an address: name 1-4, street 1-4, city 1-4, state 1-4, zip 1-4) to get the labels printed I will have to make a label layout for each one, right? Or, am I misunderstanding something here. IE a label layout for address 1, another for address 2, another... etc. Thanks for your input, you guys are the greatest...

Thanks for the reply Ralph. I did not design the database, just have to work with it and try and improve where/when I can. I kind of figured I would have to break them apart and put the data in seperate fields. Which means of course, that to print labels, I will have to design 4 different layouts. Oh well, guess you would call this job security. you'all have a great day and God bless

Thanks for the reply Ralph and Lee. What I have is database with a field called refname which can hold up to 4 names. In the "File Maker Pro 5" book by Steven Swartz these are called repetitions. And, evidently there is nothing wrong with it. Following this field are 4 others: refaddress, refcity, refstate and ref zip, each holding up to 4 entries each. I created a layout that shows all the referrals, their addresses, etc. What I tried to do is to create a label layout so I can print these referrals. Since each field can hold up to 4 different names, street, etc I have not been able to get the label layout, to show more than the first name, address, etc. Is it possible to show each of the names on the labels? If so, how? In preview or browse mode I can only see the very first name, address, city, state and zip of each of the referrals. Am I stating this correct? Sorry for the confusion.