0 Replies Latest reply on Sep 14, 2016 8:52 AM by pet2

    Find specific word occurrence from a related table in a text field

    pet2

      Hi all,

       

      My first post here so bare with me....

       

      I have a simple database with two tables: tbl_1 and tbl_2.

       

      On the tbl_1 I have two fields: 'text' and 's_code', and on the tbl_2 I have two fields: 'name' and 'n_code'.

       

      What I'm trying to achieve is that if a 'tbl_1 :: text' field contains a word form 'tbl_2 :: name' then the 'tbl_2 :: n_code' be copied to the tbl_1 :: s_code'

       

      For example in my tbl_2 I have a list of names and its codes:

      Name             n_code

      D/D                 Direct debit

      Hx46               Meals

       

      and tbl_1 I would like the s_code to be automatically filled

       

      Text                                        s_code

      d/d loan 32890004               Direct Debit

      VDC Hx46 5615                    Meals

       

       

      So far I added this formula to the tbl_1 s_code without success:

       

      If ( PatternCount ( text ; tbl_2 :: name ) = 1 ; tbl_2 :: n_code ; "No match found" )

       

      Any help would be appreciated