Jump to content

Peter Bloeme

  • Posts

  • Joined

  • Last visited

Peter Bloeme's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. In OS 9 I was able to, using Apple's "Remote Access," dial from one Mac to another through a telephone connection, connect remotely and access my FileMaker database through "Remote Host." I just upgraded to OS 10 Panther and FileMaker 8. I am now unable to find a way for the host Mac to "answer" the phone and provide me access to the network for my remote Mac. I have tried Timbuktu, but while it allows me to connect one Mac to the other, it does not provide network access. I know it is old fashioned to want to connect through a telephone connection, but does anyone have a solution for this problem? TIA
  2. I am using Apple's Address Book. My Address Book files (I think are stored in vcf format) each contain one graphic and several text fields. How can I import these records including both the graphic and text into FileMaker? TIA
  3. Did I say Newbie???-) My apology, the one idea which seemed like a workable solution was by "Comment." Unless, you all think it won't work... I was looking for a name to reference and must have scrolled too far. TIA ________________ Actually, what I had in mind is replacing a field in line items (thus "unrelating" them). But now that I think of it, this can probably done without a script, and with equijoins only. Let's say our basic TOG looks like this: Invoices - LineItems - Products - ProductCounts ProductCounts is sorted by date, descending. LineItems has a LastCountID field, that looks up from ProductCounts::ProductCountID. Products has a calculated field cLastCountID = ProductCounts::ProductCountID. Now we can add a TO of LineItems: Products::cLastCountID = LineItems2::LastCountID and calculate cOnHandQuantity (in Products) = ProductCounts::Quantity - Sum ( LineItems2::Quantity ) When another count is entered in ProductCounts, the subsequent LineItems will automatically pick up the new ProductCountID, and so will Products. So the calculation always refers to the last count of the product, and only to line items created AFTER the last count. ____________________________________________
  4. I'm glad I was able to get all you FileMaker geeks (and I mean that as a positive as I am a newbie geek) pondering...And, thanks for all your responses. I had assumed there was a straight forward answer to my, how to handle inventory, question, but apparently not. Anyway, it sounds like "Comment's" suggestion might be the most workable. Now, as far as this newbie goes, how would I actually impliment this solution? I know about the different tables: Invoices, LineItems, Products and ProductCounts. But, I'm only seeing one field in ProductCounts (a product id field). I'm assuming this is the relational field. So, can someone simplify this a bit more for me? I've read "Comment's" comments many times and, while I'm visualizing it conceptually, I still don't have the grasp enought to work it out. TIA
  5. I have developed a basic solution for "customers," with related "invoicing," "products" and "line items." They all are connected through Customer ID, Invoice ID and/or Product ID and work great. The invoices are typical in that they provide for a part number (which looks up information from the product table), along with product name, quantity, price, discount, line total and multiple product entry (through a portal to the line items table). This allows me to create product and invoice sales reports through the line items table. My question is, what is the recommended way to handle inventory where it will keep a "product on hand" field accurate and does that field belong in products? I would like the file to be able to automatically deduct or add inventory into this field depending on whether a customer orders or returns products. I would also like to manually be able to add or deduct from this field to maintain its accuracy (as inventory is received or counted). Does it have to do with a calculation, look up or related file? TIA
  6. This is not directly "related" to the previous question, but has to to with an inventory question. I have developed a basic solution for customers, with related invoicing, products and line items. They all are connected through Customer ID, Invoice ID and/or Product ID and work great. My question is what is the recommended way to handle inventory where it will keep a "product on hand" field accurate? I would like it to be able to deduct or add inventory depending on whether a customer orders or returns products. Does it have to do with a calculation, look up or related file? TIA
  7. OK, wanted to let everyone know I used the "Case" statement and it worked beautifully! Although I suspect that the "If" statement would have worked equally well. Sometimes the manual and online help just don't make things clear enough. I'm sure I will have more questions as I work through this solution, but, so far, so good. Thanks so much for your help!
  8. Thanks everyone! All those replies look great and I'm sure I can get my field to work correctly now...I'll let you know. In the meantime, if both "If" and "Case" statements will work, why choose one over the other in a formula? I've never been able to understand that. TIA
  9. I've been successful in creating a calcuation field with a basic "If Statement." If this, else that. However, I am now trying to create a calculation field that has several criteria. If this If this If this Else this However, if I code: If... Else If... Else If... Else... As I can in ScriptMaker, I get an error message that the program doesn't recognize the "Else If." So I guess I'm asking if you can have repeated "If" statements in a field definition and, if so, how? TIA
  10. OK, I don't have a reason for your problem, and noticed the same problem you did with your file, but the fix seems easy enough. "Save as" the file as a clone, no records. (I did this and then created new records, entered data into the date field and was able to search on it without trouble.) If you have existing data, you can simply import it into your new, blank, cloned file, just use matching fields on the import and it should also work for you. I suspect that somehow the file (internally) got corrupted and the only way to fix the problem is to have FileMaker recreate the file. Let me know if this works for you.
  11. Can't open it, the file is asking for a password and user name.
  12. I just had a similar "find" problem and think it's a bug in the program, but the way I solved it was by going to the definition of the date field and turned indexing off. Then doing a search on a specific date, then range. The file started working for me after that. Don't know why the problem occured for me, but hopefully that will help you. Peter
  13. David: I couldn't get it to work your way, but you led me to the following which I think is working. What do you think? Hyperflite Retailer Script Go to Layout [ “Form View” (Contacts) ] Perform Find [ Specified Find Requests: Find Records; Criteria: Contacts::State: “>1” AND Contacts::Database: “Hyperflite Database” ] [ Restore ] Sort Records [ Specified Sort Order: Contacts::State; ascending Contacts::City 1; ascending ] [ Restore; No dialog ] # Go to Record/Request/Page [ First ] Copy [ Contacts::State ] [ Select ] Paste [ Contacts::_LastState ] [ Select ] Insert Text [ Contacts::_ShowState; “1” ] [ Select ] Go to Record/Request/Page [ Next ] # Loop If [ Contacts::State = Contacts::_LastState ] Go to Record/Request/Page [ Next; Exit after last ] Else Copy [ Contacts::State ] [ Select ] Paste [ Contacts::_LastState ] [ Select ] Insert Text [ Contacts::_ShowState; “1” ] [ Select ] Go to Record/Request/Page [ Next; Exit after last ] End If End Loop # Go to Record/Request/Page [ First ]
  14. I'm not sure what you suggested is what I need to do, or I'm not following you. My found set may contain 30 unique States with 100 records total. Each State can have from 1 to many city listings (like a database of health clubs). I want to be able to mark the first record in each found State so that I can format it differently than the other cities, yet show them all. So, what I need to do is, each time I run the calculation, have the program mark the first record for each State in a separate field with some sort of flag. Thanks,
  15. I'm not a wiz on scripting so I was hoping that someone might be able to help me find the solution to my problem. I have a number of records and want to output fields with html coding to format in a specific way. I have been able to export fields so that I get the proper html code by creating fields with html in each record and then exporting them in the proper order along with the data fields. Works great. However, for formatting purposes (look on the web) I only want to include the State field in the first record of each State that I have records for. In other words if I have one record from California I want it to show up... (first record) "CA" + rest of the record If there are more than one records within the State I would like them to show up without the State field as... (first record) CA + rest of the record (second record) rest of the record (third record) rest of the record I suspect it has something to do with finding all records, sorting by state, then creating some sort of script to go from the top of the list to the bottom and setting a field to mark the uniqueness of the records and then run an if statement to go through the list and export one format if this and the other format if that for each record. TIA
  • Create New...

Important Information

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