Jump to content


  • Posts

  • Joined

  • Last visited

About Oldsneekers

  • Birthday 11/15/1953

Oldsneekers's Achievements

Community Regular

Community Regular (8/14)

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

Recent Badges



  1. On all existing clients I have a fm9 opening file that has the script "open remotely" where the user selects the "Access" file on the server from the "remote pop up window", then when opening this "Access" file on the server, causes its log-in window to pop up, for the user to enter the user name and password, which when correct, then continues the script to open all the other files with the same user name and password passed on to these other files seamlessly. This works just file for all my clients except the new laptop just acquired. This laptop accesses the server, but when opening remotely using the same opening file (or manually) the "Access" file opens WITHOUT the login window for this file but the login windows for some but not all of the files in the set do pop up (which they shouldn't as the Access file should pass on this data to all files if it functioned properly. Where is the bug? Old Clients have FM9 as the opening file Old Clients run OS 10.4.11 New Client has FM9 as the opening file New Client runs OS 10.5.x (though I call this "new" to the network it's an old G4 powerbook that's in good working order as is a back up rarely used, I think it was running 10.4x in the past but this is the first time with 10.5. ) Host has FM Server Host runs OS 10.4.11 Thanks to all for taking their time to answer.
  2. Thanks, hopefully I've paid my karmic debt for a while. Greg
  3. Clarification: turn everything off then turn on one element at a time and wait for it to fully function before turning on the next element: modem>firewall>switch>computers. Thanks again to all that took the time to help.
  4. Thanks for the input. I reset switches, turned machines off and on, checked ports and finally solved the problems of which there were many: Problem1: for some reason file sharing was off at the server (did I accidentally click this off???) Problem 2: the ownership permissions under Get Info were not on FM server and FM admin for owner and group respectively so I reset these (did I loose these when I took the file home for tweeking the gui file??) Problem 3: the IP addresses kept changing so computers couldn't talk to eachother, after trying to isolate the internet modum, network switch and multiple calls to ISP and service calls and the purchase of a new network switch, read somewhere to turn everything off and turn on in a certain order: First the internet modem, then the network switch, and last the computers. All is now working fine (did a possible power outage over a weekend cause the network switch, modem and computers all put out different IP addresses without coordination???) In any case, all is working well. I hope this helps anyone else on the verge of pulling his/her last hair out by the roots. Greg.
  5. More info... I tried to share other FM files with the various office computers with FM server off and the files simply on the desk top, and am unsuccessful. I set the computers to share, set FM sharing to share and unchecked the "don't let others see file" Each computer can "see" the other's IP address in the FM OpenRemote window but the desired FM DB (or others being tested) are not being "seen". I only have 3-4 users so within the 5 max for FM pro Any suggestion?
  6. I have FM10. Others in the office have FM9. I have the solution on FM server 9 Previously when I used the open remote file script using, I would see the desired file name in the window pop up, select it and the file would launch. All of a sudden today, after clicking on that same file name in the window, I got the message, file not accessable to user, can't open file (or something like that). What gives??? The other users CAN open the file using the OpenRemote function. I will admit I've been having very a slow internet connection for the last week and today discovered that my Lynksys Firewall is the problem so I removed it from the network, and the internet issue is not longer a problem. Are my computer's setting corrupted or is there a problem with FM9 server? Thanks for all help past and present.
  7. I use a certain font type and size as standard throughout my solution. Users have permission to cut and past text from other fields and other sources (eg: web sites, Word documents...) into my solution's fields. I want all the text to look the same. Is there a way to force the field to retain the font characteristics I want despite the formating of the text being pasted in? I tried, via FM preferences, font locking, etc... but without success. The only other way I see as a solution is have have an "Enter" button that is scripted to format the text. As this would entail a lot of extra scripting (for all the fields involved) I would prefer not to do this but if it's the only way, I'll make the time. Thanks for all your help, past and future.
  8. The first question is how do you want to use the data? I am guessing that you want to know who (customers) has what stuff (rented_stuff) and all the information about the customer (References, Employers, Landlords, Notes). The next question is will there be more than one record for each related type of data? Obviously you have lots rented_stuff and if rented, can be linked to many customers, just not simultaneously. I also assume that both Employers and Landlords can have multiple customers of yours. I'm not sure about References, I guess that's customer specific. If a given reference is likely to be linked with only one customer, than that information can be part of the customer record (in appropriate fields) rather than a separate table altogether, (but if a reference can be linked to more than one customer, that can be treated similarly to Employers). Tables and fields (some fields any way)... RentedStuff: itemName, IDNumber, ItemDescriptor. Customer: Names, IDNumber, Address, Phone, ReferenceName, ReferenceAddress..., EmployerFirstID, EmployerSecondID (assuming he works a second job to afford his lavish lifestyle , LandlordID, Employers: EmpName, IDNumber, EmpAddress... Landlords: LLName, IDNumber, LLAddress... Transactions: RentedStuffID, CustomerID, Date The tables RentedStuff and Customers have one record for each specific item. Transactions is where the action is. It is the table that relates the Customers to RentedStuff. Thus you can relate and view data Customers to Transactions to RentedStuff and visa versa. I hope this help. OS
  9. About permissions with FM server I am trying to compact my files in FMServer9. I have FMAdv10 on the server as well as FM Server9. Using FmAdv I compact the file. Change the OriginalName_Copy to the OriginalName and place it on the Desk top. I renamed the precompacted original file ( by adding _PreC to the file name) in FMServers Database folder so that my solution knows what file to access. I turn off FMAdv and turn on FMServer and use the upload function to upload it. Now I get the message "Permissions Denied". OK now I figure I have to use FMServer to "remove" the file before compacting and renaming but want to know if I "remove" it using FMServer will it be exploded into quantum bits or teleported into a parallel universe or will I find it in another folder? Is there anything else I need to know to keep my 6 file, separation model solution running smoothly and bug free? Many thanks.
  10. Thanks for the support, info and warning. I'd hate to wake up on a Monday after that kind of Sunday. OS
  11. The first question I ask myself is how is the current data entered, segregated, what constitutes a current record of data? Off the top of my head, sort of quick and dirty... If a record is StudentNamefield, ClassNamefield, HoursField, and a single student can have multiple records then the answer would be a scenario like this (assuming that each name is unique (if not than another ID needs be used) ... Table: RawData (your current table of data) Field: SummaryHours (sum of hour fields-total) Relationship: RawData ---RawData2 matching StudentNamefield (a relationship to itself) On the layout for RawData creat the field RawData2::SummaryHours Now, RawData2::SummaryHours will display the total hours for that student in whose record is resides. Note that though the student in your list may have multiple entries, RawData2::SummaryHours wil be the same for all records for the same student. If you want to segregate the totals by class, school, or other data, add these as matchfields for the relationship. Hope this helps
  12. By compacting, I mean the command under File>Save a copy as> Type of copy> compacted. I have been told, by those more experienced than I, that this is good to do every so often with large files. The only other way I see to "optimize the system" is to "Optimize" with a disc utility but that is a bit more time consuming. Any other suggests for keeping the disc tidy and the files fast? If this 'compacting' is not a good idea, why? I understood it removes unneeded disc space. Thanks. OS
  13. FM server 9 hosting files. on the host I also have FM9 advanced in case I have to do some tweeking. Problem is: after compacting a file using FM9Advanced (while FM9Server is quit) the file is accessable and modifiable in FM9 Advanced but when I switch to the FM9Server and access the file from a guest (which has it's own copy of FM9Adv with different license), I can't manipulate inside the relationship window and I can't edit records. I haven't tested all functions but these. When I put back the pre compacted copy of the file into the FM9Server data file, all is well. This occurs with all compacted copies of various files. I end up putting the original back and trashing the compacted file. I do rename the original file before substituting the compacted file. How can I compact files periodically and still have them hosted in FM9Server and accessabe and modifiable from hosts? Thanks to the teaming millions. OS
  14. Thanks for all the input, very helpful. The Big Bear suggests sending in an "executable copy". I guess this means a run time solution. Sending in the scripting does make more sense then the field names, et cetera. Thanks again. Regards OS
  15. FYI: The phone number field has conditional formatting but the formula should be "AND" rather than "OR". ("my bad") OS
  • Create New...

Important Information

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