Jump to content

cmury

Members
  • Content Count

    51
  • Joined

  • Last visited

Community Reputation

0 Neutral

About cmury

  • Rank
    member
  1. David, Sounds like a great solution! Very neat. It does sound as though we are coming to this topic from slightly different angles. From what you describe I understand you have specific search layouts that are entered in find mode. The user is navigated to these pages when they require a search. My layouts remain in browse mode but have a search field at the head of each layout. The user enters their search criteria in this field and [through scripting] this criteria is entered into multiple find requests and returned to the user. Interesting...all 3 separation solutions we've discussed will work in both of the above scenarios. C
  2. David, After a weekend of thinking this through and working up some solutions my thoughts are as follows: Method 1 - Your first solution involving pre-set reports seems to be the most efficient method of printing standard information. It's very quick to set up. However it does not deal with results from random search criteria in the UI file. Method 2 - A solution to this issue seems to be the use of a global [in UI file] and find script [in Print file]. In the UI file have a global search field [eg 'gsearch']. The user enters their search criteria then clicks a neighbouring button to execute the external find script in the Print file. This script enters 'gsearch' into various fields [you choose which ones] over multiple find requests. The script then executes the find, enters preview, prints the report and returns to the UI file. Both methods have their merits. I'm using Method 1 to generate lists of current staff, current projects etc. However, where random user searches are required - such as contacts that are male and have a name beinging with 'C' - then Method 2 seems to be a good solution. I'm still not familiar with script variables but I'm sure they could be implemented here. Questions I have are: - Can script variables can be passed over multiple files? - In a multi-user scenario are the script values held by the server or user? These are issues for another forum. I'll let you know how things develop. Thanks again for your input. C
  3. David, Thanks for your response - very much appreciated. Yes - my inital thoughts are that much of the DB structure contained in the UI file would be used in the Print file. In this respect I'm tempted to duplicate my UI file and start from there. This leaves the question of how to pass search results from the UI to the Print file. For instance - In a contact list scenario how do you pass a found set across to the Print file for printing? One solution I can see is that there are set scripts in the Print file that find predetermined sets eg All contacts begining with 'c'. These scripts are executed from the UI file. But this doesn't resolve customized search results in the UI file. For this to occur the search parameters would need to be passed to the Print file. Easy enough for single criteria but for multiple criteria eg Contacts that begin with 'C' or are 'male' .....? I think the benefits of this additional separation are significant. Particularly when generating solutions for multiple clients. The UI & Data files mature through all client intput while the Print file can be modified to suit each client's needs. Any thoughts would be great. Thanks C
  4. All, My separated DB currently involves 2 files - "Data" & "Interface". The "Interface" file currently contains layouts for printed documents/forms. I'm planning on extracting these layouts into a new file "Forms". The intention being that this file can easily be updated or easily subtituted for different Clients. Any thoughts on this would be greatly appreciated. I imagine a great deal of scripting is involved. C
  5. cmury

    Remote Question

    Thanks for your help - much appreciated. The command line option looks great - but unfortunately I'm not looking to reboot the server system. Just FM is fine. The practice also file shares from this server. So Timbuktu or Remote Desktop look like the answer. I've had a quick surf and T looks as though it will do the job and a reesonable $. Thanks again Chris
  6. All, I'm developing/managing a remote inhouse db for a small design practice in an opposite time zone. It's a separated scheme [interface & Data]. The DB is up and running - so the data is live. Both sides use OSX 10.3 and FM not FM server. I'm occassionally updating the interface file as change requests come in. This is achieved as follows: - Make changes on my local file - Request [via email] the practice admin to quit FM - Update server file via a VPN setup - Request [via email] the practice admin to re-start FM The question I have is whether the quit/start of FM can be done remotely? This would make life so much easier!! Can this be scripted? Or do I need something like Remote Desktop? Any suggestions would be appreciated. Thanks Chris
  7. I've also run into this issue. http://www.fmforums.com/threads/showflat.php?Cat=0&Number=150774&an=0&page=0#150774 Has anyone attempted to generate the global and calaulated key in the UI file and form the portal relationship on that basis? I'm thinking that all will then be native to the UI file. But I assume this process would require a 'dummy' table of vaules in the UI file. Oldsneekers - this sounds similar to your [non-script] solution. But did you require this table in the UI? I'm keen to hear if anyone has experience with this or any other work around. C
  8. See discussions in Separation Model forum. http://www.fmforums.com/threads/showflat.php?Cat=0&Number=139870&an=0&page=1#139870
  9. cmury

    Calculation?

    Thanks Ralph - much appreciated I'll take a look at it C
  10. All, Probably a simply question.... Is there a text function that returns all the values [not summarise] of a field across multiple records selected by a given value? Thanks in advance C
  11. All, I think I'm missing something in my current setup so any help would be great. I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file. KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2. My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should. I'm thinking that this could be the result of a couple of things: 1 - The value list is not truly dynamic and tending to 'choke' 2 - It has something to do with the storage of KF2 [currently set at never] 3 - A quirk with FM [i just had to put this one in!!] Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated. Thanks C
  12. All, I think I'm missing something in my current setup so any help would be great. I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file. KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2. My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should. I'm thinking that this could be the result of a couple of things: 1 - The value list is not truly dynamic and tending to 'choke' 2 - It has something to do with the storage of KF2 [currently set at never] 3 - A quirk with FM [i just had to put this one in!!] Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated. Thanks C
  13. All, I think I'm missing something in my current setup so any help would be great. I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file. KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2. My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should. I'm thinking that this could be the result of a couple of things: 1 - The value list is not truly dynamic and tending to 'choke' 2 - It has something to do with the storage of KF2 [currently set at never] 3 - A quirk with FM [i just had to put this one in!!] Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated. Thanks C
  14. Thanks Q Go it to work but with an additional line of script... Go to Field [DB::Field] Go to Portal Row [Last] Thanks again C
  15. Not sure if this is the correct forum but here goes... I have a layout with multiple portals. These all work fine and I can add/edit/delete rows in each portal. My question is really to do with adding new portal rows. At the moment new rows are created by clicking/entering on the last row of the portal. This works but is not very intuitive. What would work better is a button above each portal that creates a new portal row. I know that using Go to Portal Row [Last] will do this. However this only seems to work for the first portal. Buttons above subsequent portals incorrectly add new rows to the first portal only. I know this script is dependent on the position of the portal in the layout. But is there a method of telling FM which portal to insert the new row. Any help would be great. Thanks C
×
×
  • Create New...

Important Information

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