Jump to content

Karl Dickhaus

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Karl Dickhaus

  • Rank
  • Birthday 10/06/1961

Profile Information

  • Gender
    Not Telling
  1. OMG! I'm an idiot. When I copied the database to make the test script revisions I absolutely did forget to name the field in the test layout. Thanks! Although I must now go subject myself to 20 lashes with a wet JCL reference book! Sometimes it is the simplest things. Thanks again. The comment has now been added, too.
  2. I am attempting to de-bug a dynamic sorting routine in FMP 12 Pro that dynamically sorts a list of names when letters are typed into a search field. This is based on the "Spotlight Search" template created by David Graham in 2009. http://bittailor.com. This solution uses a single table ("Contacts") and 2 Table Occurrences - "Contacts" and "Contacts_Filtered" which are related by the Search_Field in "Contacts" equalling the Search_Index in "Contacts_Filtered. Search_Field is a global text field Search_Index is a calculated text field using the custom function "ExplodeToMultiKey" which gen
  3. Perhaps I am getting confused regarding the naming of the relationships. Is what you are saying that I should create table occurrences for each of the proposed relationships? For example, if there is a relationship Organization to Project, which links the Org_ID field in the Project table to the Org_ID (Key) Field in the Organization Table (using the = relationship) and there is a Contact to Organization relationship, which links the Org_ID field in the Contact to the Org_ID (Key) field in the Organization Table, then wouldn't you need a new table occurrence to create the Project to Project to
  4. I have a three table database in FMP 11 with the following tables: Contacts, Projects and Organizations. I have a layout that shows information on a particular project, based on the Projects table. Each project is associated with a client organization and another unrelated contact from the Contacts table - the salesperson. There is a drop-down menu on the Projects Layout for the contact person from the organization assigned to the project. This drop down list grabs information from the contacts table (a field for the contacts full name) which is sorted by the organization. For example, if Orga
  5. I said it was something basic I was missing. I had made it too difficult, interposing an unnecessary TO, I can't figure out from my notes why. Thank you for helping me past stuck.
  6. I am trying to create a filtered value list based on a property from a related table. The first table is Products. The second table is Customers. I want a value list on the customers layout that shows only the products associated with that customer's SIC Code. There is a field in the customers table that lists their SIC code. For purposes of this solution, there is only one SIC code per customer. I want a value list that will show only the products from the products table that have the same SIC code as the one shown on the customer's layout. I won't bore you with the 200 approaches I have
  7. I have an export script that exports a "Merge" file of data for use in a Word merge document. The script exports using Windows (ASCI) method, and outputs a comma delimited text file with the field values in quotations. On the Mac clients, Word will use this file to create the merge document with no issues. On the Windows machines, however, the file is not useable for merges because it contains two record delimiters. I suspect that FMP is using a LFCR delimiter to end the record, instead of just a CR. However, I cannot figure out how to solve the problem on either end. I cannot how to get FMP 1
  8. I am having the same difficulty - but only on Windows platforms. I traced the issue back to the merge file created in FMP. When opened in Word, with the "Show Paragraph Formatting" turned on, it shows an extra return after the last record. Remove this extra return, and it will merge no problem. This result did not change when "Use Smart Quotes" was checked or unchecked (I suppose the previous poster was suggesting you un-check it, on the basis that the "smart quotes" would goof-up Word). I have not found a work-around, but need one. My solution runs on both platforms - but this merge functiona
  9. I have a solution that is shared between two users - both of whom need to be able to add, delete, change and manage all the data in the solution. User 2 does not have access to the scripting functions - but can add, delete or modify any data. The solution is stored in Dropbox - in a shared folder. Both users have a copy of FMP 10 installed on their machines. They open the file and log-in as unique users (different access). The problem is that if both change records at the same time, two copies of the solution are created. One is database and the other is database (User 2's conflicted copy date
  10. I am trying to run a single script that prints first to a laser printer over the network and then to a local Dynmo 450 Label Writer. There are separate scripts for Print to Dynmo and Print to Laser Jet - these are called from the primary script. FMP 9 ignores the Print Settings, though, and just prints to the last used printer. I have searched for non-AppleScript solutions, but haven't found any that worked. This client will not upgrade to FMP 11, so I am stuck on FMP 9. Anyone have a good work-around for this issue? It doesn't occur on the PC side - same client, same solution - only on the Ma
  11. I am trying to print a report in Preview Mode, OSX Leopard, that has 5 pages. When I select print, printing to an HP 4000 TN, it will only print the first page. It does not matter which page is displayed on the screen. The "print records being browsed" button is selected. This behavior repeats across all reports in all of my FMP databases. I am at a loss as to how to get it to print all of the pages.
  • Create New...

Important Information

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