Jump to content

Scott Lafayette

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Scott Lafayette

  • Rank
  1. sorry - I assumed I was getting email notifications for replies... Yes, I would love a copy of the file, if you have something you are comfortable with sharing. Don't sweat the "brute force", I am all too familiar with these sorts of solutions;-)
  2. Have you had any luck with this? I am experimenting with a similar task and am looking for answers.
  3. Alright - I think I figured something out... When the locations are being created, by default, the location name field is being set to "Untitled". My value list is trying to cancatenate "Name" and "Address" - so I think that the value list is seeing the duplicate values in the first field and only showing the first location with that value (only showing unique values from the name field - not treating the concatenated value as a unique value). This was one of those sloppy loose ends that was left a long time ago when specs changed. It certainly came and bit me in the $ this time. I g
  4. OMG - now it is really driving me nuts... Here are two updates... I dug up an archived file from 6 months ago - before I started getting in and messing with things. The function seemed to work fine. The only change that I have made since was change the way the value list appeared (I concatenated the location name and street address field - it was originally showing just the location name field - but did not fool with the relationship at all). This morning, I was trying to troubleshoot again and one of the companies that was nto working last week IS working right now. They were create
  5. I even learned something new with that - I had never saved a file as a clone before... Here is the file... Credentials are "admin" and "pass". That should get you in full access. eX-Tracker_Pro_10-28-08v3_Clone.fp7.zip
  6. Thank you, again, for the follow up... I am not at the office right now and not on a machine with FM - I will be there tomorrow and will try to do that. I really think that I got most of the data out except for two companies and two orders to show the behavior. I guess that there must be something that I am missing, though...
  7. I just deleted a whole lot of records and got the compressed file down to 6mb. This appears to be way too big to upload to this forum. Are there any other options? Can I ftp it somewhere? Thanks! Scott
  8. Let me see if I can get it down to a reasonable file size...
  9. Thank you - I just tried turning the indexing off and on. This did not work. When I look at the relationship, it certainly appears to be a one to many to me... Also, if it is not the correct relationship, why is it working for all of the companies that were imported? One thing that I don't think that I pointed out, too - if I add locations to the imported companies, those locations will show up accordingly. Seems like maybe something is funky about how my companies are being created? I'm still at a loss... I just tried rebuilding the company table's ID index, too. N
  10. I am having a wonderful time right now with a relational value list that works, kind of... I have a company table, a location table and an order table. Both the Order table and the location table are related to the Company table by the "ContacID" field. When I create a new order, the ship location field will display a drop down value list of all related values from the location table, based on ContactID. Well, it works beautifully for all companies that were imported into the database when we went live. What I just found it, however, is that for all companies that are being crea
  11. Whooo! - that would have driven me nuts had I run into that. Thank you for the tips, again. I am in the middle of some heavy automation scripts and I am sure I will be back soon. I basically need to automate all of the monthly reporting for the accounting department. First step now is simply producing the reports. Later on, I will surely want to produce some data to send straight into the accounting system, but I don't want to get ahead of myself. So, again, thanks so much too all who have contributed! I have learned so much from this forum and continue to do so.
  12. Excellent - I got it in and it works beautifully! I tested it with a January system date and it still works. The two threads that you linked me too helped in explaining it - I will definitely be using those date functions in the future. I did search before posted, I guess it is tough sometimes because the search terms in my head don't always match what the answer is : One last follow up - I noticed that you used 2 periods ("..") for the range, instead of 3 ("..."). Are these two interchangeable? Does it make a difference at all? Thanks! Scott
  13. Man - even better! I knew that I was going to have to figure something out in January, but was prepared to deal with it then, I guess. You beat me to it and I really appreciate it! I will put that in tomorrow when I get in. THANKS! sf
  14. Excellent - I ended up doing this: Set Field (AR_LineItemsPayment::PaymentDate;Month(Get(CurrentDate))-1 and it is working. I still have a fair amount of work to do to get everything done like I need, but this was certainly an obstacle. Thank you guys, again, for your insight. I am sure I will be posting again soon. Scott
  • Create New...

Important Information

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