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 solutio
  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
  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
  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. 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/star
  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. 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 thi
  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 thi
  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 thi
  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
×
×
  • Create New...

Important Information

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