Search the Community

Showing results for tags 'text'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 23 results

  1. OK I admit it ... I'm stumped. I'm not a FileMaker professional, merely an enthusiastic tinkerer. I'm trying to create a feedback system where a series of standard questions are checked. Based on this, those questions answered 'yes' are combined together and those answered 'no 'are ignored. I have created 2 fields per criteria, 'Preset text' and 'preset question'. So ...Preset message = (if preset question 1 = yes, include ‘preset text 1’ else, blank){cr} (if preset question 2 = yes, include ‘preset text 2’ else, blank){cr} …. (if preset question 10 = yes, include ‘preset text 10’ else, blank){cr} I've managed to get the display of answers based on yes/no, but I can't get rid of the blank lines. I'm am probably going about this the wrong way, so any suggestions? thanks
  2. Hello FM Mavens, I would like to be able to change an attribute (happens to be the size) of a selection in a text window with a script. (Basically, as if moving the size selector from the Formatting Bar into a button on a layout). I created a script that cuts the selection, puts it in another text field, makes the change, cuts it out and goes back to the original field but by then the insertion point is gone. I can manually paste it back of course. I wonder if there is a way to remember the insertion point somehow and make it a so the paste step uses it. Thanks Asu
  3. Hi All, I am trying to parse text from a Job Card Items table into the related Job Card and not getting the correct result.. as the Items in the Job Card are completed any anomalies have to be reported on the Job Card and with up to 50 items in the Job Card Items there may be more than one anomaly to report, (very rarely more than two) . If the Findings field is empty I am just inserting the Variables but when the field already contains data I am using this to parse the text: Position ( JobCard::Findings ; ":" ; 1 ; 1 )&¶ & $ProdName &" "& $ItemLocation & " " & $QItemSerial On the second insertion I am getting this: PR00023 FC iLLume Unit FC0000084 Unit damaged:46 PR00023 FC iLLume Unit FC0000084 Where is the 46 coming from ?
  4. Troi Automatisering releases Troi Text Plug-in 4.0.1 for FileMaker Pro 15 June 22nd, 2016, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 4.0.1 for FileMaker Pro 15. What is new in version 4.0.1? Version 4.0.1 is further optimized for use with FileMaker 15. In this version we made description and type-ahead information available for all functions of the plug-in. This extra function description will be shown in FileMaker Pro 15 in the Specify Calculation dialog box when you type a function name and also as a text popup in the functions pane on the right. The type-ahead information is used by the auto complete functionality of FileMaker Pro 15. More detailed information on all changes and improvements implemented in Troi Text Plug-in 4.0.1 and earlier can be found at: http://www.troi.com/software/texthistory.html Pricing & upgrade information A fully functional version of Troi Text Plug-in 4.0.1 is available for downloading at Troi's web site at: http://www.troi.com/software/textplugin.html. Licenses cost US$ 49 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site. Upgrading to version 4.0.1 is free for all users of version 4.0: version 4.0.1 works with the same registration as the 4.0 version. Product updates from earlier versions, bought on or after August 7th, 2015, are FREE: eligible users have been emailed a new 4.0 registration string. Contact us if you have not received yours. Upgrades from licenses bought before August 7th, 2015, are available from US$ 29 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site. Contact information D. Budding Troi Automatisering Newsroom: http://www.troi.com/news/
  5. Hey all, I'm trying to debug a de-duping script I have which runs after importing records. The script works by sorting the imported list by a match field, iterating through the found set and marking any record with the same match field ID as the previous as a duplicate. It mostly is working fine except in this one case which has me stumped as the values of the strings in each comparison are different but the condition tests "true". In the following code example when I run a comparison on the a1 and b1 derived values, c returns "1". If I use the static a2 and b2 values, the condition tests "false" (as expected). I have checked the derived b1/b2 values in the data viewer and confirmed they are identical to the a2/b2 values. Any idea what might be happening here? Let([ a1 = "DgP5cPJYR"; // static match string A a2 = $id; // resolves to "DgP5cPJYR" b1 = "DG5GvtJlR"; // static match string B b2 = GetField(Get(LayoutTableName) & "::" & $matchField); // resolves to "DG5GvtJlR" c = If ( a1 = b1 ; 1 ; 0 )]; //c = If ( a2 = b2 ; 1 ; 0 )]; a1 & ¶ & b1 & ¶ & c //a2 & ¶ & b2 & ¶ & c ) a1 & ¶ & b1 & ¶ & c returns... DgP5cPJYR DG5GvtJlR 1 and... a2 & ¶ & b2 & ¶ & c returns... DgP5cPJYR DG5GvtJlR 0 This has got me stumped I have to say... any help appreciated.
  6. Hi Forum, Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation: IF(Order_Number = "PT00*", 1, 0) Thank you for assisting, Miss-Amen!
  7. I'm struggling to remove quotation marks from a symbol/operator such as this: "<" I have tried Substitute (Text; "\""; ""), as well as Brian Dunning's custom function RemoveSmartQuotes (text). Both works in the field of question perfectly with normal text, such as {hello "world"} ends up being {hello world}, but ho matter what I run "<" through, the quotation marks remain untouched. Any ideas?
  8. Hi everybody I have an error using scriptmaster 4.42 release when I try to convert a pdf file into text. I have no problem with 4.201 release. The function reurns ERROR and SMLastError is set as "java.lang.NoClassDefFoundError: org/bouncycastle/cms/Recipient" My function is defined as "import java.io.IOException" & ¶ & "import com.itextpdf.text.pdf.PdfReader" & ¶ & "import com.itextpdf.text.pdf.parser.PdfTextExtractor" & ¶ & ¶ & "if( fm_filePath == null ){ throw new Exception(\"File path required !\")}" & ¶ & "if (new File( fm_filePath ).exists()){" & ¶ & " try{" & ¶ & " reader = new PdfReader(fm_filePath)" & ¶ & " sb = new StringBuffer()" & ¶ & " for (int i = 1; i <= reader.numberOfPages; i++) {" & ¶ & " sb.append(PdfTextExtractor.getTextFromPage(reader, i))" & ¶ & " }" & ¶ & " return sb " & ¶ & " } catch (IOException e) {" & ¶ & " e.printStackTrace()" & ¶ & " return \"IO ERROR.\"" & ¶ & " } catch (Exception e) {" & ¶ & " e.printStackTrace()" & ¶ & " return \"ERROR.\"" & ¶ & " }" & ¶ & "}" Starting from SMLastError I added bouncycastle jar in my filemaker solution. No change, so I tried to add as well such as import steps : "import java.io.*" & ¶ & "import java.util.*" & ¶ & "import java.security.*" & ¶ & "import org.bouncycastle.jce.provider.BouncyCastleProvider" & ¶ & I found these steps on other forums, but without any documentation, it looks like fishing... One thing changes : when I use "import org.bouncycastle.jce.provider.BouncyCastleProvider" SMLastError becomes java.lang.NoClassDefFoundError: org/bouncycastle/cms/RecipientId instead of java.lang.NoClassDefFoundError: org/bouncycastle/cms/Recipient Thanks in advance Olivier
  9. Troi Automatisering releases Troi Text Plug-in 3.5 for FileMaker Pro 14 August 10th, 2015, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 3.5 for FileMaker Pro 14. What is Troi Text Plug-in? Troi Text Plug-in is a powerful tool for for dealing efficiently with text in your FileMaker Pro database. It adds the following functions to FileMaker Pro: - Parse XML text into fields- Combine sets from 2 text fields: - get all lines that are the same - get all lines that differ - and other combinations- Get (unique) lines and sort words and lines- Make a text sum from a related file that updates without a script What is new in version 3.5? Troi Text Plug-in 3.5 offers the following changes: - Tested and made compatible with FileMaker Pro 12, 13 and 14.- Added support for 64-bit architecture with FileMaker Pro 14: on OS X the 32-bit and 64-bit version is a single universal plug-in and on Windows there are 2 plug-ins: Troi_Text.fmx (for 32-bit) and Troi_Text.fmx64 (for 64-bit).- Added the example file EasyInstallTroiPlugins.fmp12, with support for the 64-bit version of FileMaker Pro 14.- Tested with OS X 10.9 Mavericks, OS X 10.10 Yosemite and Windows 8.x.- Troi Text Plug-in is now compatible to run under FileMaker Server. The plug-in creates log files when running under FileMaker Server to make troubleshooting easier and to provide feedback regarding errors and registration status.- Added new switch -GetRegistrationState to the TrText_Version function to check if the plug-in is currently registered.- Added new switch -GetPluginInstallPath to the TrText_Version function to return the path where the plug-in is installed.- Added new switch -UnregisterPlugin to TrText_Version to remove the registration data. The plug-in will be in the unregistered state after this.- Several bug fixes and further improvements.- Converted the example files to .fmp12 format and made various changes to the example files. More detailed information on all changes and improvements implemented in Troi Text Plug-in 3.5 and earlier can be found at: http://www.troi.com/software/texthistory.html Suggested Uses - Receive client information in XML format and parse it easily into your database- Find all addresses you want to send an email to, without sending duplicates- Create an index for a book, which is updated automatically- Keep track of your client relations by generating a dynamic history of activities- Present portal information horizontally Pricing & Availability A fully functional version of Troi Text Plug-in 3.5 is available for downloading at Troi's web site at: http://www.troi.com/software/textplugin.html Troi Text Plug-in 3.5 works with FileMaker Pro 12, 13 and 14. The plug-in can also be used with runtimes created by FileMaker Advanced 12, 13 or 14. The plug-in is available for OS X 10.6.x or higher, Windows Vista, Windows 7, Windows 8 and Windows 8.1. Licenses cost US$ 49 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site. FileMaker Server requirements Troi Text Plug-in 3.5 also works with FileMaker Server 12, 13 and 14 as a server-side plug-in and as a plug-in used by the web publishing engine and WebDirect. To use this, you need to purchase a special cross-platform Server/Web license which costs US$ 259. We have prepared extensive information on how to install and use Troi Plug-ins server-side and web-side on this web page:http://www.troi.com/support/filemaker-server-side-plug-ins.html Upgrade information Product updates from earlier versions, bought on or after February 1st, 2015, are FREE: eligible users will be emailed a new registration string. Contact us if you have not received yours after August 12th, 2015. Upgrades from licenses bought before February 1st, 2015, are available from US$ 29 per user.Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site. About Troi Automatisering Troi Automatisering develops professional iOS apps, is a leading developer of cross platform FileMaker Pro plug-ins and winner of the FileMaker Pro Excellence Award 2001. For more information, visit our web site at:http://www.troi.com/ Contact information D. BuddingTroi Automatisering Newsroom: <http://www.troi.com/news/>
  10. Hello everybody I'm trying to convert number to text en dutch but it doesn't work i had some problem with the calc field when i m trying ( some are good but other doesn't work) is there someone that can help me to resolve this little problem cose i m not a dutch person I join the file that i made to be more clear In advance thanks u cardinal2txt NL.fmp12
  11. i want to import into filemaker from a text file which is a result of a http request. (in filemaker 11!) actually, what i get back from the http-request in a browser is a simple OK 1204888105 now, if i do this via filemakers script step “Import Records” and XML Data to be able to write a http request, i get the obvious error: XML parsing error: invalid document structure Line Number: 1 Column Number: 1 so i was wondering, if there is a possibility to write a XSL style sheet, that can help me grabbing this text into a record. a style sheet, that presents this short text to filemaker as XML data ? thanks for any thoughts ! klaus
  12. I have two text fields, text1 and text2. Text2 is a product summary, consisting of the first paragraph from text1; text1 is a product description and varies from record to record. I set up the following to automatically populate text2: text2=LeftWords ( text1 ; Position ( text1 ; "all words left of the first paragraph symbol" ; 1 ; 1 ) ) The problem I'm having is what goes where I typed above "all words left of the first paragraph symbol". How to tell FileMaker Pro to find and recognize text control values? For example, many word processors would recognize ^p^ as a paragraph marker. I tried various combinations with and without "" from this page: http://www.fileformat.info/info/unicode/char/001e/index.htm But no success because obviously there is some text encoding that I don't understand. So the question is: how does FileMaker Pro find and use the paragraph character in a block of text please? Thanks. I'm using FileMaker Pro 13 Advanced on a Mac.
  13. Hello, I am a FM newbie and have been scouring the web for an answer to this problem: I want to eliminate the text within parentheses in a string, but I want to eliminate all instances: ORIGINAL STRING: This is a test of the (emergency) broadcast system. (It is only a test). Remain calm. DESIRED STRING: This is a test of the broadcast system. Remain calm. Can anyone help? Also, is it possible to tie the function or script to a field so that when the ORIGINAL string is put into the field, the field does the conversion automatically? thanks very much in advance, SB
  14. Hi there,  I have a database where i have some related tables with different information regarding an order. I want to create a customized email for the customer with a standard text, and some variables that will vary, depending on which record they are related to(different costumer data, order data etc.).  Is this possible?    I get a lot of errors when i try to customize the email this way - do i need to make "" or () in order to include more than one field in the message?  Or is there another way to do this?  Thnanks in advance,  Mike
  15. Hello guys, newbie intern here. I am placing a .text document inside a container. I am trying to grab the text out of that container without doing so manually, can anyone help me out?
  16. Hi Everybody, I have a text field with a text that contains normal and red-bold characters, I would like to count the number of characters with bold style. Could anyone help me to do this operation with a function? I am trying to do an script that extracts the portion of normal text to calculate the length and then calculate the number of total characters minus normal text. What is the best option? a function or an script? Thank you very much, Wardiam
  17. Hi ... I can't get to work what I think should be something very simple. Our users write large fields of text. Several times they've complained because they've lost an hour of typing (medical report) Filemaker connectivity has been lost. Usually a power outage or VPN issue. I've tried to get them use to clicking outside the field and then back into the field to commit the data but I continue to hear "Why can't it autosave? Just like Word" .... Well ... I created a timer script that gets launched by an OnObjectEntry trigger. It then waits 60 seconds and then gets the cursor position using get(ActiveSelectionStart), does a set field to itself and then positions the cursor using the Set Selection. This works fantastic when typing a new entry and the cursor is at the end. Problem is when you try and edit the text in the middle of the text, the save kicks in and the next character is "selected". This causes the character to disappear when the user carries on typing. Is there no function to simply position the cursor?
  18. I got bit yesterday and today by a basic issue. I was using the Data Viewer to write and test ExecuteSQL. The context was an old part of a solution I had started in 2006. I was having trouble with JOIN. I checked syntax and could find no errors but constantly had "?" returned. I knew the problem was related to the JOIN because the queries worked fine without it. Well, I'm embarrassed to admit the problem was this. The parent table had an auto-enter serial PK type number. All the child tables had an FK field but the type, for some reason, was Text. FM allows this as a match! Of course SQL does not. After changing all the child table FK fields to type Number everything was fine. Multiple joins we're a breeze. Why is FM so loose about field types in a relationship? This situation ought to produce an error in my opinion, or simply not work.
  19. Hi, I'm getting some output from a vendor called Fillz and it's coming to me in text form as follows. I'm running a pricing script on their server. (Note: I have put a return between record sets though there isn't one in the real output. There are 7 "records". The first number is the SKU (Stock Keeping Unit) I want to see the info as follows (in FMPRO) I just don't know how to separate it out. SKU: Base Price: Condition: Floor: Sales Rank: Total Offers: Lowest Six Offers ( If I can separate out each of the lowest six offers into separate fields ie: (Lowest Six Offers P1, Lowest Six Offers P2, etc.) Price: New Price: Change at Amazon: 072310-5-76 *** Base: 4.99, condition: 3 Floor: 3.99, sales rank: 28038, total offers: 1715 Lowest 6 offers: [[{P=2.28;S=3.99;C=11},{P=2.29;S=3.99;C=11},{P=2.5;S=3.99;C=11},{P=3;S=3.99;C=11},{P=3;S=3.99;C=11},{P=3.64;S=0;C=3}] OfferList] price: 2.79 New price is: 2.79 price 2.79 is smaller than floor 3.99. Applying floor. change @ Amazon $4.99(base $4.99) -> $3.99 aw-1-100812-1064 *** Base: 6.99, condition: 2 Floor: 3.99, sales rank: 1124921, total offers: 627 Lowest 6 offers: [[{P=2.99;S=3.99;C=6},{P=2.99;S=3.99;C=5},{P=3;S=3.99;C=5},{P=3.18;S=3.99;C=11},{P=3.2;S=3.99;C=11},{P=3.21;S=3.99;C=11}] OfferList] price: 3.10 New price is: 3.10 price 3.10 is smaller than floor 3.99. Applying floor. change @ Amazon $6.99(base $6.99) -> $3.99 0509101-5 *** Base: 4.99, condition: 2 Floor: 3.99, sales rank: 3844790, total offers: 157 Lowest 6 offers: [[{P=0.01;S=3.99;C=2},{P=3.59;S=3.99;C=11},{P=3.99;S=0;C=1},{P=3.99;S=0;C=2},{P=5.99;S=3.99;C=11},{P=6;S=3.99;C=11}] OfferList] price: 3.93 New price is: 3.93 price 3.93 is smaller than floor 3.99. Applying floor. change @ Amazon $4.99(base $4.99) -> $3.99 0618101-3-56 *** Base: 4.99, condition: 2 Floor: 4.25, sales rank: 1161427, total offers: 181 Lowest 6 offers: [[{P=0.01;S=3.99;C=2},{P=0.01;S=3.99;C=2},{P=2.75;S=3.99;C=6},{P=2.75;S=3.99;C=6},{P=2.89;S=3.99;C=11},{P=2.9;S=3.99;C=11}] OfferList] price: 1.89 New price is: 1.89 price 1.89 is smaller than floor 4.25. Applying floor. change @ Amazon $4.99(base $4.99) -> $4.25 0625101-1-7 *** Base: 4.99, condition: 2 Floor: 3.99, sales rank: 1069137, total offers: 689 Lowest 6 offers: [[{P=0.65;S=3.99;C=11},{P=0.7;S=3.99;C=11},{P=0.88;S=3.99;C=11},{P=0.91;S=3.99;C=11},{P=0.95;S=3.99;C=11},{P=0.99;S=3.99;C=11}] OfferList] price: 0.85 New price is: 0.85 price 0.85 is smaller than floor 3.99. Applying floor. change @ Amazon $4.99(base $4.99) -> $3.99 f011411-j3-6 *** Base: 4.75, condition: 2 Floor: 3.99, sales rank: 23059, total offers: 1310 Lowest 6 offers: [[{P=0.01;S=3.99;C=2},{P=3.75;S=3.99;C=11},{P=3.75;S=3.99;C=11},{P=3.79;S=3.99;C=11},{P=4;S=0;C=2},{P=4.35;S=3.99;C=11}] OfferList] price: 3.28 New price is: 3.28 price 3.28 is smaller than floor 3.99. Applying floor. change @ Amazon $4.75(base $4.75) -> $3.99 f1-091112-x1-655 *** Base: 4.75, condition: 2 Floor: 3.99, sales rank: 23059, total offers: 1310 Lowest 6 offers: [[{P=0.01;S=3.99;C=2},{P=3.75;S=3.99;C=11},{P=3.75;S=3.99;C=11},{P=3.79;S=3.99;C=11},{P=4;S=0;C=2},{P=4.35;S=3.99;C=11}] OfferList] price: 3.28 New price is: 3.28 price 3.28 is smaller than floor 3.99. Applying floor. change @ Amazon $4.75(base $4.75) -> $3.99 Thanks kindly, David
  20. I have a checkbox set with 30 'topics' for children's games. Some games can include any topic, so I want to check all the boxes. I created a script with 'Insert Text', and listed all the topics as per the value list. which does the trick nicely to select all the topics with one button. However, as the database grows, I think of new topics, and I don't want to keep updating the value list, then this script etc etc... Can I use the data in a value list as the text to insert in an 'Insert Text' script. I have tried without luck. Thanks so much.
  21. Hi All, I want to validate a field to be not empty and contain a specific number of digits if the text in another field meets specified criteria. I have a field called Account_type, if the choice in that field is "Account" then I want to force the inclusion of a ten digit account number in the Account_Number field but only if the text "Account" is specified. I know this should be an easy If or Case statement but I am not getting it right.
  22. Hi all, I'm new to the forum--and new to programming FMP for my boss! I understand the logical concepts of programming, and how the FMP UI works for table relationships and scripts, but I don't know specific function commands. Now I'm trying to create a database for the manufacturing company I work for, and can't find a function to create a text string I want in a calculated field. Apologies if this question has already been answered, but I can't figure out how to word a search for this!! I have two tables related exactly like the "Contact Management" and "Notes" tables in the starter template: each record in table 1 has an "k_ID" number that matches a group of records in the second table (all having that same number in their "kf_ID" field"). There is another field in table 2 whose contents are a digit from 0-9. This field is the "Item Batch #". I want a calculated field ("Batch Code") in table 1 to paste the values of "table 2::Item Batch #" from ALL related records strung on end, whether there is 1 related record or 5. I've tried typing an example of what I mean....my company won't allow me to attach copies of our file, sorry. records are separated with ------------------------ lines. EXAMPLE: =========== ==TABLE 1== =========== k_ID: 01 Batch Code: 253 ------------------------ k_ID: 02 Batch Code: 67 ------------------------ =========== ==TABLE 2== =========== kf_ID: 01 Item Batch #: 2 ------------------------ kf_ID: 01 Item Batch #: 5 ------------------------ kf_ID: 01 Item Batch #: 3 ------------------------ kf_ID: 02 Item Batch #: 6 ------------------------ kf_ID: 02 Item Batch #: 7 I really appreciate the help, if I can have a solution by tomorrow morning it will mean MAJOR points with my boss! I'm on the west coast, so I'm rooting for all you people further east who'll be perusing the forum with your Monday morning coffee earlier than I will! Thanks again.
  23. Apologies, as this is no doubt simple, but I haven't figured out the vocab for an effective search, hence my question: Project Table project serial # Event Table project serial # event date event detail There are multiple Events/Project. I'd like a calc field in Project to string all the related Events as text (event detail1, event detail2, event detail3, etc). What could be easier? It would preferably deal with commas, and would ideally put them in the right order (reverse chrono), but for now I'll take ugly and alpha if it works. Many thanks in advance, /capisco