ori_wel

I should probably have this one, but cannot get it. I have a large data file (DAT). I have an interface file (INT) with many reports (and no tables) which uses the external DAT as its datasource: same number of records. If I am in DAT with a given found set, how can I navigate quickly to the same found set in INT? I had envisioned using GTRR, but there is no relationship between the two files. As a bonus, is it possible to preserve Sort order? Thanks in advance! DSW

Any new news on a release date for Filemaker Server Advanced 8? "Fall 2005" has passed! Thanks. DSW

Regarding tab interface ... Improve the Go to Layout step - Have it become Go to Layout [tab#, tab#, ... ] Unless I use a Go to Field step, I cannot consistently navigate back to a specific tab. If I am missing something here, let me know. Thanks. DSW

I would like to script a process by which I save multiple copies of the same file. But I would like each file to save a specific found set - a subset of the records in the file No problem with the Find, the loop, the dynamic filename and path. My particular issue: Is there a good way to do a "Save a Copy As..." with only the FOUND SET of records, without the need for a clone file and doing a bunch of imports? Thank you in advance for your thoughts. DSW

Thank you for your response. For a number of reasons (i.e. portability, backup's), in this case anyway, it is preferable to have individual files. DSW

I have a file with several thousand event records. Each event is assigned to one of several hundred managers whose name is in the Manager field. I wish to automate a process which does the following: 1) Create mutliple copies of the file. 2) The individual files created contain the records associated with each Manager only (i.e. Smith's file contains 10 Manager="Smith" records). 3) The filename would contain the manager's name and the enclosed record count (i.e. Smith_[10]_Fall_05.fp7). Can anyone suggest a best route to take? Many thanks in advance. DSW

You are tremendous!! That is absolutely perfect. Many, many thanks. DSW

In my web site, users can submit text along with the bold, underline, and italics html tags. i.e. [b]Some[/b] text like [u]this[/u] I need to create a calculation field translates the html tags into actual formatted text. I propose to use: Substitute( text ; [b]substring[/b] ; TextStyleAdd( substring ; Bold ) ) However, I do not know how to isolate the substring, particularly when there might be multiple instances within the same text field. Any advice would be much appreciated. Thanks in advance! DSW

Fenton, Wow did that hit the spot! Just perfect. By applying the PositionValue() CF to the result of the AppendNth (a.k.a. GetNthRecord()) CF applied to a self-referencing relationship, I get the local value for the nth related record. Now I can find a single record for each among a group "child" records. Also, finally, no ValueListItems(). Big help! Many Thanks. DSW

I have a list of records in a "child" database, for which some data is repeated. Think a list of students where each student may have multiple records, one for each of her classes. I need a field which says basically "which portal row the record would appear on in the 'parent' record." If David has seven classes, I want his first record to say 1; the second, 2; etc. I don't want a summary field. GetSummary() is not of much use in my opinion. Is there a way to hard code this field? I have seen others do cool things with GetNthRecord, and I have adapted it to my own use (i.e. replacing GetValueListItems). I feel the answer is close. I would value and appreciate and feedback you could offer. DSW

Thank you. I agree. I appreciate your referring me to that link. DSW

I would like to get the contents of a "child" portal to appear in a single field in the "parent" table. I am familiar with the method which uses the "get (valuelistitems)" for a value list made up of related values. Is this still the best way to do it, or has anyone discovered an alternative? Also, is there a way to get the nth (i.e. 2nd, 3rd, etc.) row in a "child" portal to appear in a field in the "parent" table? I have no solution for this one. Thank you! DSW

Hopefully, this is a simple one. Thanks in advance for any tips. Simplifying, I have a data table called BIO which contains many records and a large number of biographical fields. Records can contain one or more entries in a Category field (i.e. Student, Faculty, Parent, etc.) My Interface table has a large number of layouts which are useful for viewing biographical data from each category. My TO to the BIO table happily populates the layouts with ALL records in BIO. It would be extremely useful if I could Toggle between SUBSETS of BIO records. In this way, I would not have to have multiple copies of the layouts. Is there a way to have such a "Dynamic TO" which when, for instance, "Student" is selected in a global, all Student records appear; "Faculty" selected provides a collection of Faculty records; perhaps with checkboxes, I could view several subsets simultaneously. I have read all of the Filemaker articles exhaustively, but have missed this feature ... if it exists. Thanks again for any wisdom you might be able to provide. DSW

You are very generous with your response. Sorry for the delay in getting back - I stepped away for a bit for other matters...Thank you very much for your good advice and these useful tools! DSW

Thank you both for your careful and informative responses. Barbeque (Dev7), can you comment about how FMP7 handles text formatting? I believe I read that you can preserve user formatting in a calculation. Say I have a field called NOTES into which a user has pasted Willie's Wiggleworms size 12, with the exception of the first sentence which is W'sW bold size 24. If I were to create a calculation field called NOTES_c = NOTES and set the print font to be TimesNewRoman size 11, would this NOTES_c change the font to TNR but preserve the bold in the first sentence? How would it handle the size changes? Thanks for any further assistance you can offer!