Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Curtis_B

Members
  • Content Count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Curtis_B

  • Rank
    novice
  1. Awesome! Thanks Lee, I didn't realize that the 2nd find request would also inherit the ship date limitation of the first request. I assumed a 2nd find request was a concurrent OR type of request (in this case, allowing any ship date).
  2. Hello, I've been a FM7 user for 4 years now, and I do consider myself to be pretty well aware of what can be done and what can't. However this request threw me for a loop this morning. Our accountant asked for a report of all orders that shipped out of state in 2007. In my mind, I'm thinking that means I need to find a ship date of 1/1/07...12/31/07 AND the state does NOT equal MN. I am aware of the 'omit' flag for finds, but have never really needed to use it. I'm not sure how that would help me in this situation since I also need to limit the year to '07. I'm stumped. I ended
  3. I had this same problem and solved it. Your post didn't mention installing mysql connector, I'm assuming you already know about that step and have done it. http://www.mysql.com/products/connector/odbc/ This is what happened to me, I installed the connector, and Mysql still did not show up on my System DSN list and I was baffled. I eventually found this thread on the mysql forum: http://forums.mysql.com/read.php?37,31449,31449#msg-31449 As it turns out, this is a glitch with the mysql connector installation (I think) but it doesn't affect everyone. The fix is to locate a
  4. We have an invoice counter field which is global. It basically just keeps track of the next invoice number to use. We need this to simulate an auto-increment (although it can't actually be an auto-increment for reasons I won't get into here). As it stands, we use a global field, which works great for one person, but of course does not work well for multiple people. I'm trying to figure out how I can setup this invoice counter to stay current across multiple users. Any input would be appreciated. Thanks, Curt
  5. Yes, that attachment was a tremendous help. I have never set up a condition as a relationship to a new table occurence before. I didn't even realize I could do that. Thanks, problem solved Curt
  6. Awesome, that did satisfy my simple example. Thank you. Now, here's where things get complicated. Each claim is considered either 'on time' or 'late'. I can represent this status in a number of ways. My Ultimate goal on the list of office locations is to calculate the number of 'on time' claims vs. 'late' claims. To add another level of complexity, this number will be based on a user inputted date range (globals, I currently have them in the office locations table). So basically, I want to add conditions on top of this summary. Any suggestions? I apologize if this explaination is t
  7. Maybe it's getting too late for my brain, but I'm stuck on a concept here. I have two related tables, office locations and claims. Each office location will have many claims. Each claim will be linked to only one office (by inputting an office id). For the sake of clarity I will simplify my objective in this post. Lets say I want to have a list in the office locations table, where all offices will be listed row by row. For each row there will be a calculation telling me how many claims that office has in total. I'm not sure how to accomplish this. I know that in SQL I would b
  8. I'm hoping to do the sql equivalent of 'select distinct' in a filemaker find. I'm in version 7. I know I could write a script to give me distinct values, but I would hope this is a built in function. The manual makes no mention of such functionality. Thanks
  9. Does anyone know how to get rid of the 'no found records' dialogue box? I hate the fact that my employees can (and do) press cancel when they need to be continuing the script that is running. thanks
  10. I come from a php programming background. I'm trying to do something in filemaker where the script would check if something exists, and if it does not, then carry out certain procedures. In php, it's a simple if statement like this: if(!$variable){ then do this; } Let me know if you can tell me how to do this, I appreciate it. Curt
  11. Thought I would speak up here. I have a php/mysql site running remotely on our webserver and FMS running locally on our network here. We love FM for our in house information system, and php/mysql on the web end of things, so I recently developed a solution that automatically replicates FM >MySQL daily (or could be as often as needed). There is no need for incoming web>fm data for our solution, so it is just intended to display information. When I get some free time I'll document how I did everything and post it in this forum. Curt
  12. Good Afternoon, I'm working on my first bar code solution in FMP. My reader terminates with the Carraige Return/Enter key. This will perform a find if I am scanning the search criteria, however aside from the finds, I'm hoping to use barcodes for data entry purposes in browse mode (tracking production progress in a manufacturing environment). If I'm in a script that is in browse mode and pausing (using the pause/resume script step) at a field for scanning (and moving on) the Carraige Return/Enter key does not resume the script, it merely starts a new line in that same field.
  13. I have noticed Stanley mention that barcodes can trigger scripts. He even posted the code for [ctrl-1] for use with code 3 of 9 as being *$H1$J*, unfortunately for me that does not trigger my ctrl-1 script in filemaker using the same barcode font. What I'm hoping to do is have a list of barcode script triggers (ctrl-1, ctrl-2, etc) so each employee can scan the specific task (script) and then our physical job ticket (invoice number). So after the script is initiated it will pause in the invoice number field, until the job ticket is scanned and then the information has been properly updat
  14. I've finally figured it all out today. I have successfully setup an EFFORTLESS filemakerpro >> MySQL solution. I am very excited about this. So far I only have it going for one table, eventually this will be setup for all tables that apply. What happens is this, a filemaker pro script triggers the entire process: -show all records (optional) -sort records (optional) -export records (must be a tab seperated text file) -open url (local batch file ftpconnect.bat) -open url (remote php file www...import.php) the ftpconnect.bat uses windows command line ftp commands to conne
×
×
  • Create New...

Important Information

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