Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Himself last won the day on March 13 2012

Himself had the most liked content!

Community Reputation

0 Neutral

About Himself

  • Rank
  • Birthday 02/24/1979

Profile Information

  • Gender
  • Location
    New York
  1. Makes sense to me. I will give that a try as soon as I can and post the outcome. The only minor bump is that the Edit screen is also the New Project entry screen. Now currently a user will click "New Project" from the home screen menu and go right into the edit screen and create the new project and when complete get dumped into the full view tab of the record they just created. To maintain this I would need a goto related record but I would then lose what was previously stored in the found set. I may just dump the user back out to the screen they originated from. Thanks for the help.
  2. I don't monitor the acctual Workers so I noticed that the project I posted is way past due so thier boss should be monitoring that. We are a US public school and our budget has been slashed and people let go so they are probably understaffed and haven't yet adjusted. I tried go to related record... I think but can't remember why it didn't work. Doesn't that too break a previous find? For example, a user needs to edit all the projects relating to a specific building so they go to the find tab and perform the find if the results are greater than 1 they are automatically dumped into the li
  3. Well when a user creates a project from scratch nothing is entered so the entire form is blank the form is based on the Project table but all the WorkOrder elements need to be filled in too. When the record is finished the user is dumped out to the "view only" navigation screens and is now viewing the Project they just entered. The view Only navigation screens both List view and "full or single" view are based on the Project table so the only script step needed is "go to layout" when moving from one to another. This is also true of the "Edit" screen, which is the new record screen except da
  4. Well this Database was requested by someone higher up the foodchain than me. I told them that Projects are redundant as they are just workorders with expected start and stop times while work orders are open ended driven by demand. These projects are also navigated separately from Workorders the two don't share any space together in front end operations they have separate search screens data entry screens etc.. not my wishes either in my opinion it added extra uneccessary work. Well perhaps it was my folly but I chose not to reinvent work orders to satisfy Projects and decided to just
  5. I did not include a dependant value list in the simple file and perhaps I should have however it doesn't really change the problem. The problem is refreshing the form after selecting a value from a value list that is dependant on a related table not the one tied to the form. This problem occurs with drop down lists and pop up menus alike. Something that is not evident in the sample and I don't think has been clear is that the relationship between the work order table and project table is not 1 to many. There are many more Work orders than there are Projects not all work orders have pr
  6. Yes the drop down list displays the value stored, that is the crux of the problem. This is 2012 the relational database is dominant no longer do flat files reign. I can't even really think of an instance when I would use a drop down list that isn't storing a record "ID" value and if there are reasons they are few and far between. Record "ID's" shouldn't be in the forefront of the user interface so doesn't this effectively make the drop down list useless? Well no it doesn't because there are "work arounds" so you can get some of the features of the drop down list like auto complete and scro
  7. Actually I fully believe they can do simple stuff. I like Filemaker, sure it has its limitations and quirkiness but everything does. Sorry if you took offense to my statement, however it still holds true since drop down lists and pop up menus are different and one can't always be swapped for the other. Your statement only strengthens my point since they "have been around for 20 years" and this feature exists in pop up menus. So why has it yet to appear in drop down lists they have had the time and they can implement the function? Now while using a pop up menu will work in showing the
  8. I apparently don't know how!?! How awful is that? I made a simple file but can't figure out how to attach it. What’s the secret?
  9. Commit records is not optional a refresh alone doesn't update the Edit box; but than the user would be hit with record validation messages since they may not have filled in every other part of the form. I also have to find out what version of FM everyone is using and get them all upgraded. I suppose I could turn off the record validation and use a scripted save button for record validation. Any other ideas?
  10. I have a form which uses a drop down list to store an ID and an edit box overlay to show the related value chosen. (still baffled that FM hasn't just made that a native option) The problem I am noticing is that the Edit box only refreshes when one clicks on a blank area on the form. I have drop down lists in other forms that refresh their edit boxes as soon as a value is selected. The difference being that the ones that refresh immediately, the drop down list field is from the table the form is based on, but if the drop down list field is based on a related table it doesn't refresh imm
  11. It works! Thanks again for the push in the right direction.
  12. I wouldn't expect many records per user per day. Ideally they attempt to schedule a Technician to be in one building for an entire day but life is not always that simple and the need to move Technicians around always presents itself. I would say the max might be 4 locations in a day but the majority will be 1 or 2 locations in a day. I had come up with using a calculation field in the Appointment table to identify the destination location. That would then link to the Mileage table nicely. The calculation in that field was my next step so I will look into your suggestion tomorrow since
  13. Based on the previous record. So for example: 1, 3/27/2011, 8:00 AM, 9:00 AM, Rob C, AHS, Install Stuff 2, 3/27/2011, 9:00 AM, 12:00 PM, Rob C, CAO, Meeting 3, 3/27/2011, 8:00 AM, 10:00 AM, Glen B, AMS, Alpha Project 4, 3/27/2011, 1:00 PM, 4:00 PM, Rob C, AMS, Alpha Project 5, 3/27/2011, 1:00 PM, 4:00 PM, Glen B, AMS, Alpha Project 6, 3/27/2011, 10:00 AM, 12:00 PM, Glen B, Out, Doctors Appointment As you can see the records won't necessarily be created in the proper order but using the date and time stamps they can be sorted by Date,Person, StartTime. This is why the prob
  14. In my organization we have 15 buildings within a county that we have fixed distances between and offer mileage reimbersment. Our Technicians use a FM DB to track inventory and work orders on the inventory. Within this DB is a built in Scheduling system to assign the Technicians to a building for all or part of the day in instantances where the Technician travels between buildings they are entitled to mileage reimbersment. The Director of Technology now wants the FM DB to track the mileage for the Technicians since the information is already in the DB and produce a report for the Technician
  • Create New...

Important Information

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