Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About TaiChi56

  • Rank
  • Birthday 10/30/1958

Profile Information

  • Gender
    Not Telling
  1. TaiChi56

    Searching multiple off of one value set

    Excellent that worked great but now that led me to another problem I did not realize I had because I imported these records off of an EXCEL spreadsheet. When making a new record is there a way to add those same "USE" criteria in the one field that uses a drop down from the value set or would it be better to just make that a regular edit box? Would that work? Thank you.
  2. I have a value set that goes to a field called "USE" the value set has the following: Patriotic, Contest, Concert, Festival, Broadway, Popular, Folksong, Christmas, Spiritual, Novelty and Mandrigal Is there a way to be able to highlight more than one of these "USE" and do a search? Example: I want to search the database for a Christmas song that is also a Broadway Play and a Festival piece? Christmas and Broadway and Festival. Can this be done with a drop down box? I cannot seem to be able to do this with the Find Operators. Thank you.
  3. Thank you. I appreciate the answer.
  4. Is it possible to create a custom menu but keep the find that Filemaker incorporates? The one by the "Delete Record" I cannot seem to find it when I create a custom menu. I really like that Search feature so I would not have to create custom ones. Thank you. Let me rephrase this. Why does the Find Icon go grey in the status bar when you use a custom menu. I cannot seem to get it to work in a custom menu.
  5. Thank you. I am having them put their Excel file in the same directory and folder where this database will be installed. I will try this. Again thank you.
  6. Ok, here is what I am trying to explain. The database is built for other people to download. I will not be there to be able to import for them. So if a person gets my database and has an EXCEL spreadsheet of their library I am giving them the option to import into their new database via a script. But I noticed on their initial database that if they do not understand that it already imported that they will click on the import button again and now they have doubled their imports. Does that make sense? I will then have a script where they can update their database by Excel if they want later on when they get more data to add.
  7. I have a script for the user to import an EXCEL file into the Database. I noticed though if the system is slow for some reason and the user does not look at the records tab to see that records have been imported the user may click import again thus doubling the data. How do I keep the user from inputting the same data twice? Here is my script: Go to Layout ["Choir Catalog Details" (ChoirCatalog)] Import Records [With dialog:off; Source: "CatalogImport.xlsx"; Worksheet: "Choral"; Add; Windows ANSI] Show All Records Thank you.
  8. You are a GENIUS!!!!!!!!!! That worked. Cannot believe I missed that. Thank you so much.
  9. I turned off dialog. Here is where I am trying to save it. file:C:/Users/SixCore/Desktop/"Catalog.xlsx" Still getting the same error.
  10. Perform Find[] Save Records as Excel [With dialog:On; ""Catalog.xlsx""; Automatically open; Records being browsed] Go to Layout [original layout] Show All Records I am getting the following error: ""Catolog.xlsx"" count not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. I have a 2 TB drive with plenty of room. I have renamed it several times and made sure that it had full user access. When I debug I get this: Last error: [800] Unable to create file on disk I have made scripts many times before for EXCEL export and never had this problem. I have searched for an answer and have not found one.
  11. TaiChi56

    One table of information to four titles

    Thank you to both of you. Sorry it took so long for me to reply. I will work on your suggestions. Thank you.
  12. Thank you to both of you. Sorry it took so long to get back and reply. I will work on both suggestions. Thank you. 

  13. How would I make one table meet four categories in my relationship. I am doing a choral music database for our school. So I have the following: Mixed, Men, Women, Small Ensemble. Each of these libraries have the same information such as; Title, composer, Arranger, Lyricist, Voicing, etc..... So when I person clicks on Mixed they get all the information categories that they would get if they picked Men, just different information in them. So would I just make four tables of the categories and have each one have a Primary key, then make on table with all the information fields and have a PK, and then each of the categries would have the FK? Thank you.
  14. TaiChi56

    Table to print receipt

    Sorry. Yes we are tracking individual pieces not a kit. The student may not receive the same piece the next year as he progresses. If one is broken and lost then we replace it with another one. I hope that answers it.
  15. TaiChi56

    Table to print receipt

    This is equipment that was issued to a football player. If they do not return it then I want to give them a receipt showing what they owe. If the lose it or break it then they still owe money.

Important Information

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