Jump to content

HELP! Trying to "empty" a file of its data so all reports are blank

This topic is 2600 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This could very well be a very complicated question, but I'm hoping that someone with far more knowledge than me will have a quick answer to this issue.


I have created a financial database that I use to display my boss's financial information via different reports.  Let me first say that I KNOW there is a better way to do this, but I have managed to make this work for almost five years, so I'm just looking to fix this one issue, not restructure my database.  No question about the fact that I probably did things the hard way.  Oh well... :cry:


I use this database file only for the current year.  I generally make a copy of the file and then erase prior year data so I can start fresh.  However, some data must remain in the database, like budget information.  I enter the actuals on a monthly basis. 


I have one report that is called "Cash Flow Summary" that is mostly portals used to display the relevant data for each month.  Each month remains blank until the data for that month is added to the file. However, when I generated this report for the first month in 2014, it found data for future months that doesn't exist in the current file, and some fields that are blank when there is data to be displayed.  I have compared this report structurally with prior years to see what I may have done wrong, but everything looks identical.  I even compared prior years that worked to other years that worked and cannot see where I'm going wrong in 2014.  They all look the same structurally. 


As an experiment, I made a copy of the file so I could erase EVERYTHING and see what happens with this report.  The Cash Flow Summary report is still pulling data from other sources even though the file is empty of records.  I just don't get it.  I tried to attach the file, but it says I'm not permitted to upload this type of file. :hair:


I'm not sure how I am going to get assistance if I can't provide the file for someone to review.  Anyone who can offer a suggestion here will be greatly appreciated.


Thanks in advance for your time and assistance. :thankyou:



Link to comment
Share on other sites

To Attach a file, follow these steps. HERE


In addition, I am going too move this to a Different Topic because this Topic is reserved for discussion of the Tools, Functions and Features that were new to FileMaker, and introduced in this version of FileMaker

Automatic message

This topic has been moved from "FileMaker Pro 11" to "Managing Scripts".

Link to comment
Share on other sites

This topic is 2600 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Clayton King
      First, I appreciate any help I can get as this project has been evolving over two years and, as these kinds of projects to, has become more involved and complicated over that time. I've posted related questions, but exploring other parts of my project. As I'm not a programmer, but a sort of user nerd, my inquisitive mind wants to learn, but sometimes simple concepts elude me. Feedback, both on the specific goal at hand as well as the project overall is always appreciated.
      Performers is one piece of a much larger project, but I'm trying to enhance the project and working on a piece at a time. 
      I'm sharing the entire project layout to provide some insight into how the parts fit together. The application is a booking management tool for performers, consisting is several tables as shown:

      Again my focus right now is the Performers table and how to use it in relation to the Gigs (and Gigs~Songs_Join) tables.
      There is a Gigs layout which is the hub for performances by one or more Performers. On that layout is summary information about a gig and a portal which shows which songs were performed and in what order (Set & Slot fields). The portal also includes a Performer Name. The assumption at this point is that up to 4 performers will do a given gig. This might change in the future, and could impact the below goals.
      Gigs~Songs_JOIN is a connecting table for Gigs, Performers, Songbook, Venues, Musicians, etc. Performers is a table of singers and includes fields for a serialized SingerID, name, area of speciality (Tenor, Baritone, etc.), etc., and additional fields for combinations of the same performers including: 
      Multi: checkbox-indicates this record is more than one performer
      PerformerName: calculated based on Multi: if NOT Multi, show performers Name, if Multi, show MultiName (below)
      Type: value list-is this a duet, trio, quarter, all, etc.
      MultiName: the description of this record (i.e., Duet-Clayton/Vicky)
      Other summary fields include:
      Total Gigs: count of gigs in which this person has performed
      Total Songs: count of songs this person has performed
      GigID: match field to Gigs~Songs_Join

      I have two goals, one related to the other. First, if the Performer record is checked Multi, I want to "attach" or "associate" individual singer(s) to the record (i.e., show what people are "included" in the MultiName). For example, MultiName=Duet-Clayton/Vicky, I want to show that Clayton and Vicky (each in separate records) are part of Duet-Clayton/Vicky.
      Second, ultimately on the Gigs layout, I want to show which Performer sang which song (currently works in the portal), but more importantly, show variable summary information (goal layout below) which changes for each Gig as to each Performer, how many songs they sang and the total amount of time they sang. The catch is, in the summary I don't want to show the Multi records, but instead increment individual singers. So, in the summary info with related portal records in the example below, rather than showing Clayton sang one song, Vicky sang one song and Duet:Clayton/Vicky sang one song, I want to show Clayton sang 2 songs and Vicky sang 2 songs. In summary info, Duet:Clayton/Vicky wouldn't appear. In other words, the summary would show how much time each person was singing.

       In the summary block of the Gig's layout, each of the above sets is a one-row portal filtered by set. I want to have the SINGER1,2,3,4 replaced with the actual Performer's name, and each band/portal show summary info for the appropriate singer. 
      Here is my relationship graph:

    • By Answers
      We have a Filemaker Go on iPads and there is a layout with portal rows, when scrolling through it hesitates and you must wait to scroll down. We have offline files on the iPad, although it happens when we connect to the Filemaker server as well.
      Any suggestions?
      Thank you,
    • By Matt.C
      I'm hoping someone might be able to help, or at least point me in the right direction.
      I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. 
      It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. 
      Any suggestions on how I might be able to achieve this?
      Many thanks!

    • By dkey
      I find in an old drives some fmp5 files. To open them in FMP18 I need to convert them first to FMP7.
      I have an old version of FMP7 however each time I install it the app crashes telling me the installer was modified with another version and crashes.
      I tried to download from the Filemaker site the trial version but I can't find it ... any help?
    • By FMRadio
      Basic Question:
      I am attempting to import 60 records from a CSV file. There are 4 fields per record: First Name, Last Name, Email and Source. 
      When I choose Import Records... > File... from the File menu, everything looks good, 4 data points point to the correct field names: arrow icon "Import this field" but the rest are the double dots icon, "Don't import this field," and when I click on the Import button only the first record is imported.
      I don't use Filemaker frequently enough to remember everything but when I need it, I really need it. I do not remember having to go thru and changing every icon in the Import dialog to import this field, I thought that was automatic.
      I there something missing in the CSV file? I can reprocess that if required. Having to indicate to import for every record will be tedious.
      Thanks in advance for any help.
  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

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