Mike Janus

Additional information. Sorry. I'm using Filemaker 19 on Windows 7. Thanks for your suggestions. I decided to do a new layout and your comments helped. I now have a single column which prints on two pages as I wanted it to do. Thanks again very much.

I have a layout which is a list of names and addresses. There are 7 records and on the layout they are displayed from top to bottom. However, because he list is too long to fit on one page, when I print this list, the last two records print as a partial second column (apparently they are too wide) and not as a second page. How can I get the list to print as only one column and when it reaches the bottom of the page, print on a new page instead of as another column? Additional information. Sorry. I'm using Filemaker 19 on Windows 7.

Daniele, I finally got a chance to see your reply. I tried it out, and it worked perfectly. Thanks very much for your help. Mike Janus

This has to be covered somewhere, but I couldn't find it. I'm using FM9 and I want to sort a title field. I need to enter the title with the initial "The" "A" or "An" but I want the sort to ignore those. I want the title The Age of Anxiety to sort it as if it were Age of Anxiety. Many people must have had this problem, but I can't figure out what to do. It's a shame FM doesn't have an automatic sort which will do this, but since it doesn't, can someone suggest how I can do it? Thanks. Mike

I want to thank the recipients to my original question. I posted it on the 9th and then went out of town on the 12th. I hadn't had a chance to get back to the problem until now. I'll be taking a look at all the possibilities, but I think I need to brush up on Join. I'll check out the FM help file--unless someone has a better suggestion. Sorry for my silence until now. I do appreciate the time people take to help with problems. Mike

I'm working with Filemaker Pro 8 on a PC. I have one file called Adults.fp7. Each adult has a unique ID as well name and address fields (fullname, address1, address2, citystatezip, and phone) I have another file called Students.fp7. In this file, I have, among other fields, four fields called Parent1, Parent2, Parent3, Parent4 (in today's world, this family arrangement is not uncommon). In those fields, I enter the unique ID from the Adults database. I want to then display from the Adults database the relevant name, address, , and phone information for each of the four parents. I've tried setting up the relationships in both databases in various ways, but nothing seems to work. I can get the information from Parent1 to show up in the Student record if I use a simple relationship of Parent1 to Adult ID. But as soon as I add a relationship of Parent2 to Adult ID, neither Parent1 nor Parent2 information will show up. Can anyone suggest a solution? Mike

I am using Filemaker Pro 8 on a PC. I can't find anything in the Knowledge Base which deals with changing a file name. I have some database files which have scripts and relationships with one another. I want to change the name of a couple of the files. Two questions: --What is the best method for changing an fp7 file name? Should I change it in Windows Explorer or should I change it in Define File References--and if so, how should I change it there? --What will happen if I change the file name in terms of script references and relationships? Will I lose or have to recreate scripts and relationships? Any advice would be appreciated. Thanks. Mike

No updates that I'm aware of. I use XP Pro, and although I'm notified of all updates, they are not downloaded and installed until I do it myself. That hasn't happened in a week, I think. Mike

They are different files used for totally different purposes and with completely different information. One is related to business jobs and the other is related to a part-time teaching job I have. They have utterly no connection with one another.

This is spooky. I previously asked about a problem with three related databases which were suddenly asking me for passwords. Now another databased completely and totally unrelated in any way to the previous three is asking me for a password when I never set one and have not changed anything in it between yesterday and today. This new database suddenly asking for a password is stored on a totally different computer and is for a different business. I'm using FMP 8.0 v.3. WHY is this happening? Mike

If the Log in using must be checked, then what do I put for the Account and Password. I don't want to have to enter this every time I open the file. Mike

Urgent help needed. I have three databases which had been working fine with no problems. Then in the last two weeks or so, they have been erratically asking me for passwords. I've checked File Options in the dropdown File Menu (which does have a blue checkmark next to it), but in all three, the Log in using... is NOT checked. In the last two weeks, sometimes I couldn't open the db by clicking the file name or doing a File Open, but I could get to the other two by going into one of them and opening the other two from it (because they're all related). All of a sudden today, I can't get into two of them at all. They continue to ask me for non-existent passwords. No one else has access to these files. What can I do about getting into these databases? Mike

For starters, I'm in FMP8.0 on a PC with 1 gig of ram and lots of storage. I know there has to be an easy solution to this, but I'm drawing a blank. I have three databases for a school-type setup: Participants Offerings Enrollments Participants keeps the student information including ParticipantID, LName_FName, phone, and email. There is only one record for each participant. Offerings has the class information, including Offering and Offering_Year_Semester (a single field which with the concatenation is a unique field). There is only one record for each Offering_Year_Semester. Enrollments has the sign-up information including classID, studentID, and status (participant or facilitator--a person may be a participant in one or more offerings and a facilitator in one or more offerings). There is only one record for each combination of classID and studentID. Relationships: Enrollments is related to Participants (studentID to ParticpantID) Enrollments is also related to Offerings (classID to Offering_Year_Semester) Participants is also related to Enrollments (ParticipantID to studentID) Offerings is related to Enrollments (classID to Offering_Year_Student) I need a separate report for each Offering which shows the name, email, phone number, and status of each participant in that Offering. In Offerings, I can do a layout which will give me a separate report showing the offering at the top and then, in a portal, shows the name, email and phone number of each person in that offering--because those three items are all in the participant database to which the offering database is linked. However, I can't add the status since that information comes from the Enrollments database. When I put the Status field from the Enrollments database into the portal, it shows only the status of the first record in enrollments (I think). What it shows is that all participants in the Offering are participants and not picking up the fact that one or two of them are indicated as facilitators as entered in Enrollments. Any of this make sense?