2 Replies Latest reply on Jul 15, 2011 7:44 AM by JohnAnderson

    Repeating Text Field Overflow to next repeating text field

    JohnAnderson

      Title

      Repeating Text Field Overflow to next repeating text field

      Post

      Using Filemaker Pro 9, I have created a purchase order database which pulls information from our parts database, based on the part # I put in. Based on the part # I enter, it retrieves the part #'s description from a separate part # database and enters that part's description into the purchase order database.  

      EX: I enter in part # 1234. When I tab to the description field, the description is automatically populated from the part # database so I get:

      Part # 1234  Description:  Bearing

      The problem I am trying to resolve, is that sometimes the description doesn't fit nicely into the description field. When it doesn't fit into the description field, the extra description text flows underneath the text that fits.

      EX:

      Part # 4561  Description: Bearing with steel casting, Diameter 4.5"

      width 6.5", inner diameter 1".

      However the extra text is hidden by the next blank description line.

      What I have been doing to get around this, is cutting the excess text (Ctrl-C) and pasting it into the next line's Description field (Ctrl-V). I would like Filemaker to do this automatically though.

      Can anyone help me, possibly with a script that will tell filemaker

      1. If the # of characters in description field is greater than EX: 30 characters

      THEN Copy characters 31-40 into next description text field  (etc. etc.)

      Thanks!