Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About mmcconnell

  • Rank

Profile Information

  • Industry
    Higher Education
  • Gender
  • Location
    Southern California
  1. I'm trying to create a simple inventory system of digital music (downloads) sales so that licenses can be properly tracked. We have to purchase a license for each song sold. I'm having trouble with one part of the reporting. I receive a CSV from the vendor that lists 2 types of transactions: single track (song 1, song 2, etc) and complete album (Album 1 which is made up of song 1, song 2, etc.) I can successfully report totals on the single tracks using a Summary field in the table, but I'm unsure of the best methodology on how to include the songs sold when a complete album is reported. I
  2. Clients are all Mac OSX 10.6.8. They are also bound to AD and OD in that order. FMP 11.0.3 and FileMaker GO iPad There are no passwords stored in the client keychains. Files do not open automatically with stored credentials. FileMaker groups are made from AD accounts, stored in OD groups (i.e. fmpStaff is a group in OD that contains AD users Bob and Steve). Why have I done this? My systems have been set this way for more than 5 years. Our department is all Mac with local server and XSAN storage. The company provides AD from another location. All servers and clients are boun
  3. I am perplexed by this situation: FIleMaker Server on XServe running 10.6.8. XServe is bound to Active Directory and Open Directory. Hosting 1 database. Database Server configuration is set to FileMaker and external server accounts under Client Authentication. All groups in OD match what is in FileMaker The Issue: When a user attempts to authenticate to the database, he receives an error message that the account will not work. He is then presented with the authentication dialog box again. As long as the user does not modify any information, incl
  4. Certainly a creative solution. I'm not sure I see the purpose of the opening script. The global field value will not change and will not be displayed to the user at any point. Also, I have more than one value list that needs this functionality in the real database, so it would be nice to make this a truly global solution.
  5. From what I am reading, this may be impossible or at least improbable. I have a table of status made up of the following: status_ID;status_active;status_sort;status_text It is related to a contacts table via the status_ID in a 1 to 1 relationship (i.e. each contact can have 1 status). I am storing the status_ID value in the Contact table. My question: I would like to be able to keep a user from selecting an inactive status from a popup list and I would like the values to be sorted by the status_sort values. I have previously programmed in MS Access, and creating a
  6. You are again, correct. I am breaking the "rule" of trying to solve a user-caused problem with a technological solution. There is no technical reason that the annual award cannot be input at the same time. I have a meeting scheduled with the stakeholders next week where I will try to convince them that what they are asking for is not feasible and their data entry policy needs to change if they want the report to be in this format. Thank you so much for your help and suggestions!
  7. This, as I am sure you know, is a brilliant solution you have created, and takes me 99% of the way there. I have been testing the implementation of this all morning and I have hit another brick wall. I need to summarize Fall 2011 and Spring 2012. The solution you created works well if the year is the same, but not with different years. I have modified the report, adding another global called gReportYearSpring and modifying the spring portal to match. This now gives me correct data in both fall and spring fields. Updating the summary portal with an OR statement now gives me exactly the exp
  8. In this example, test 1 has a status of Enrolled and no data for spring. test 2 has another status; award is not seen. test 3 has different amounts in fall and spring and a status of Enrolled. Thank you.
  9. I believe this is where I started. If ( Semester="Fall" and Year=2011 and Students::Status="Enrolled"; Award ; 0 ) This works exactly as intended with the fall amount. The issue is that I need to show the spring amount on the same line, even when there is no spring amount in the database at this point. That is the reasoning behind reporting the fall amount twice and summarizing fall and spring amounts. I need to show all three values on one line for each student: ID|Name|Fall Amount| Spring Amount|Total Amount|Last Modified Date I am running this report from the Students table. The user w
  10. I do need to show absolutely everyone on the report. This is a requirement of another office on campus. I am attempting to put my data into a format used by everyone else on campus.
  11. Greetings! I am new to this list. I am trying to build a report that utilizes several calculations and I seem to be going around in circles with If and Case statements. This is for a student tracking database. One student ID number can have many scholarship records (they are in 2 different tables). Values are hard-coded for testing; they will be user-selectable in the final UI. I am trying to report on the current semester (fall 2011) and the next semester (spring 2012) individually and then reporting the sum of those 2 amounts. The reporting of the amount is also
  • Create New...

Important Information

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