Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About trmupstage

  • Rank
  1. I've noticed that my server C drive is starting to fill up with FM log files. Especially: C:Program FilesFileMakerFileMaker ServerAdminadmin-master-tomcatlogs That directory is around 1.3GB of just log files. Can I safely delete logs? Is there an automated way within FM Server to clear out old logs. I'm using FM9 advanced server. Thanks
  2. Thanks for the help! It worked fine. I did say "shift" - f a bunch after being unable to edit. Thanks again.
  3. OK, I'll admit it. I'm an idiot. We have an old database that we only need to view, so I changed the automatic login account to View Only permissions. I believe there is an admin account setup, but the database is set to use the default login automatically. So now, I can't get in a do anything with the database. Is there a way to force login as a different user? Like I said, under file options, I have it set to login as a specific user. I don't see a way to login as a different user. Any ideas? Thanks for the help.
  4. Sorry, I didn't mean to imply that I was getting a poor solution from Barbara. I am grateful for all the help I'm getting. There have been a few things in FM that I think must be easier to do than they appear. It's not that they are overly complicated, it's just that I wasn't understanding some of the structures used in FM well enough. Once I finally get the principal down, it all comes much easier. Thanks again for the help.
  5. Thanks for the link. I found an article and example on there. From reviewing the example file, I see that it is not as straight forward as I thought it would be. The example I found uses a calculation in the sort setup of the portal. I was thinking that maybe there was a simple script. Possibly not. I'll keep searching.
  6. Hi, I have an issue where sorting does not appear to work, either as a script or manually. Let me explain. I have an inventory table, line item table and a purchase order table. The purchase order layout has a portal to the line item table. The relationship from purchase orders to line items and inventory to line items works fine. I can add parts to the purchase order and adjust stock with the purchase orders. In the purchase order layout, I want to create buttons on the labels above the portal to sort the portal records by the label. Seems simple enough, but I can't get it to sort. Even if
  7. I got that going. Now when the Lock field changes value, the user can no longer edit the record. One more thing though. They are still able to run the scripts that are attached to buttons in the record. Any way to change that? I know I can add some traps to the scripts to prevent them from running if the Lock field is set. I just don't know if there is a better way. Thanks for all the help.
  8. Thanks for the quick responses. Do I understand it correctly, that to make this work, I need to setup a new privilege set. I would then setup custom privileges for the edit of the particular table based on a calculation of: LockField = 1 Do I have that right? I would then make a script change the value of LockField to 0 when the record is complete. The user will actually hit the button that completes the record. We just have too many times where they go back in searching for something and they end up changing the data. Like some other things with FM, it takes a bit to get your head
  9. I've been looking for hours but still have not come across any posts that tell how to lock records. We will have a number of records being shown in a portal. When the "Status" field is set to "Complete", I want to prevent anyone from making further changes. Up till that point, it is fine for them to make changes. It seems like there should be a function called "lock record" or something like that, but I can't find anything. Could it be called something else? I'm using version 7 and version 9. BTW, 9 has some great new features. I was glad we bought it. Thanks for the help
  10. Thanks for the tips. I ended up using a Qty Received and a Quantity Previously received field to handle backorders. When a part arrives, you type in the quantity that came in. The backorder field is calculated. Then the quantity received field is added to the previously received field and then the quantity receieved field is cleared. I adjust the inventory based on the quantity recieved field, and adjust the Backorder field by Qty - QtyPreviouslyReceived. I also added another field to show the status of each line item. When something is backordered, the status line says "partial" when we got a
  11. Thanks for all the helpful replies. Yesterday, I made some real advancements. I've got the relationships working well and I'm able to adjust our inventory correctly. I used scripts to adjust the inventory when either a part was used or when it was received. I put a few extra things in there to prevent people from doing stupid stuff too. The scripting thing will give us a lot more possibilities. I never jumped in to it before. I'm glad I did now. I've ordered version 9. I got a dozen copies for the normal users and I bought advanced for myself. I'm not sure what the differences are, but I
  12. Yes, you're right. I realize it is all customized. It would have helped me a lot if the examples that come with Filemaker were done a bit better. Even the new Inventory example it the business pack is based on relationships across different databases, instead of using multiple tables. It just got a bit frustrating putting the pieces together. I've also noticed that there are many, many ways to do the same thing. I've been studying as many examples as I can find. Everyone seems to do things a bit differently. I was finally successful in getting the relationships working in my database. I
  13. Well, I'm still trying to figure it all out. I've downloaded every Filemaker example I can find. It's amazing that there are no simple, functional examples of multi-table databases used for inventory, invoicing and PO's. All the examples I found were either way too complicated to grasp or they simply don't function properly. After hours and hours of messing with this, I'm kind of burnt-out. I normally write code for embedded controllers. That has some logic to it's structure. I feel like an idiot working in Filemaker. Like most programming puzzles, I'll probably stumble on the answer while I'm
  14. Thank you. I'll check that out. I really appreciate all the help.
  15. Thanks for the links and the advice. I downloaded Business Tracker. Wow! that is very impressive. I could spend a long time learning from that. I'll keep researching this till I get it. my main job here is designing and writing software for embedded controllers. It's amazing how stupid I feel working in database design. Thanks for the help. I'm sure I'll have a few more questions before it's all done. One last thing: Your comment "I'll leave you for now with this advice: don't use an unstored calculation to track your inventory totals, it will eventually become too slow. Use a script o
  • Create New...

Important Information

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