13 Replies Latest reply on Dec 14, 2009 1:14 PM by philmodjunk

    muti user related finds in a portal

    MikeDunglinson

      Title

      muti user related finds in a portal

      Post

      I have a main customer file which is related to a stock (inventory) file. The user enters his find criteria into a Global Field (FIND ITEM) in the main file.

      Then using a script I insert the calculated text "FIND ITEM" into the stock description field and perform a find. This finds the selected records in the stock

      file. I then replace the contents of the "STOCK LINK" Field in the stock file using the contents of the Global FIND ITEM Field.

       

      The Relationship is   Main File "FIND ITEM" =  Stock File "STOCK LINK"

       

      So Now I can display the found items in a Portal on the main customer screen

       

      This works no problem until I introduce additional users.Then if two users (or more) use the same script one of the users may lose some items

      from his portal. This is because:

       

      One may search for "glass"

      another may search for "sight" 'glass'

       

      The 1st user will find all records containg "glass" and they will have the STOCK LINK field set as "glass"

      The 2nd user will find only records containing "sight" but some of these will also contain "glass". The STOCK LINK field is set as "sight"

       

      The result is that the relationship link for the records found by the 1st user are partially lost and all records containing "sight" and "glass"

      are taken out of his portal.

      I have used Filemaker for many years (since V4) but I am struggling with this one. I would prefer to keep the "Portal finds" rather than take the

      user to the stock layout when searching stock items

       

       

      Any Help would be greatly appreciated

       

      Mike