Jump to content


  • Posts

  • Joined

  • Last visited

RJN's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Thanks very much for the offer. Let me review what I have and plan my strategy over the weekend, plus create the clones and be sure they are properly organized and cleaned up. Then I will contact you back and send the three files. Many thanks! RJN
  2. I have a need to take three database files that I had created earlier under FMP 5.5 and combine them into one database, as three tables within that database. The three databases are now relational to one another, and for the most part things are working smoothly -- it would allow for more efficiency, though, if they were all part of the same file. It's my understanding that the more advanced Filemaker Pro can do this, but I have the standard FMP Version 8. Is this possible in my version, and if so can you point the way to how to do it? Many thanks. Incidentally, I have the wonderful book, Filemaker Pro 8: The Missing Manual, by Coffey and Prosser -- if the solution is in there, and I just have not found it, you can simply point me to the right pages.
  3. Thanks -- I think it could work. My main issue would be keeping it uncomplicated so that a non-Filemaker user can operate it. But very much worth a try. RJN
  4. In post #198974 I asked for help constructing a method to track zip codes of audiences for the non-profit performing arts center I run. Using the suggestions provided, I was able to construct a very usable method, and it is now functioning very well and saving my staff a lot of time. Many thanks to those who offered help -- I used all of the information to good advantage. My next question has to do with our contracting system for the performance groups that rent the venue. Each event has its own record, that lists, among other data, the date on which the user's deposit is to be made, and the date on which the final balance is due. There is no specific time relationship between these two due dates -- the sequence of when a deposit is due and when a balance is due is determined by factors that don't allow a mathematical relationship (such as balance is due 90 days after the deposit, etc.) to be employed. I need to construct an easy method to see (in a portal, perhaps, or in a separate layout, ALL the due dates for the entire season (all users and all events), so that my staff can track and know each week what payments are due, and be ready to call the user if the payment does not appear on time. Additionally, this would be very useful in projecting cash flow for income from week to week and month to month. If there were only one date in each event record, it would be easy to set up a report, a lookup, or a portal showing all dates in sequence. But we have two dates for each record, so I need a way to split them apart from the record that holds them, and place each date in correct sequence with all the other dates in the season's lineup of events. (Along with the date, into whatever reporting/viewing method is constructed, would go the name of the user group, the amount owed, and whether it is a deposit or a final balance payment -- I figure that can be done relationally and I know how to accomplish that part of it). Can anyone suggest a solution? We would ideally like to have a method that allows a non-proficient user (our office manager) to click on a Button that runs a script that gets the report easily and simply for her, AND/OR view it in a layout that is accessed by a Button, AND/OR view the information in a portal that is always present and visible on the screen in a particular layout. Many thanks -- RJN In posting this I saw a message that indicates it may be in the Tips and Tricks Forum, which is not what I intended -- meant it to be under "How do I..." My apologies, please move it where appropriate. Where can I find instructions on choosing the specific forum for a post -- this happened to me once before and I would like to correct it.
  5. Thanks -- will try this over weekend as I develop rest of the process. Appreciated.
  6. I am moving along in developing the Zip Code database described in #198987 in response to my initial request for help in #198974. (Thanks to all for ideas!) I would like to speed up Zip Code entry by using the Enter key to perform a script (creating a new record for the same Event ID, for example, so that the next Zip Code can be entered). I cannot find in any of my FMP books how to use the Enter key to perform a script. Can anyone educate me on this? If I can't use the Enter Key, then can I assign some other key to this, such as Tab or a letter key, F1, F2, etc.? Many thanks -- (Apologies for multiple submissions -- I thought I was experiencing a freeze of some sort and hit Submit too many times.)
  7. Many thanks for above -- will investigate each idea. There is no need to identify a seat number with a zip code: the greatest degree of specificity required is to gather zip codes relevant to a particular performance. Ultimately, simplicity and speed of operation for the office staff are most important, since time is tight and assessment of zip codes is important material for our funding stream as a non-profit arts organization. Thanks again. Encouraging to know there is so much knowledgeable and enthusiastic help out there. Any other ideas, anyone? Thanks again.
  8. I have a 350-seat performance space. For each performance we ask our patrons to give their Zip/Postal Codes at the door when they enter. I need to keep a record of each performance and number of each Zip Code recorded. Most fall in the range of the 40-or so Zip Codes in our metropolitan area, but some happen to come, at random, from Zips we have never recorded before, perhaps from outside the state. I need some advice on the fastest and/or most efficient way to enter all 350 Zip Codes in an individual record for each performance, and have them, if at all possible, self-tabulate as to the number of patrons from each Zip Code. Can anyone point me in the right direction as to method? If I were doing this in Excel I would use something like a Pivot Table - is there a FMP equivalent? Ultimately we have to add up the totals of each Zip Code for the entire year, but I believe I have a focus on how to do that. Thanks.
  9. RJN

    Height of a layout

    Good point, thanks -- will try. Sorry for incorrect posting forum -- I am new to this and was not aware I was choosing the wrong forum. RJN
  10. RJN

    Height of a layout

    Thanks for thoughts. This is for a contract form that needs to print out in about 11 pages. There are a number of fields and calculations embedded throughout the contract, thus the need for a continuous document. My backup solution is to edit the contract as tightly as I can and reduce type size.
  11. RJN

    Height of a layout

    I am trying to create a layout in FMP8 which is higher that the maximum that seems to be allowed: something around 111 inches high, according to the rulers on the screen. I need this layout to have another page or two, taking it to around 130 inches or so. Is there a way I can break through this apparent maximum layout height? Thanks for any help.
  • Create New...

Important Information

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