1 Reply Latest reply on Oct 31, 2013 6:49 AM by philmodjunk

    Search for an equivalent record

    Maikel

      Title

      Search for an equivalent record

      Post

           I am looking for a script that compares two tables and shows records that the does not match. The unique feld what the search command first distinction is Project_id.

           as VoorCal::project_id matched Werkbon::Project_id than seeking all records that do not match

        • 1. Re: Search for an equivalent record
          philmodjunk

               If the two tables are linked in a relationship:

               VoorCal::project_id = Werkbon::Project_id

               Then

               If [Not IsEmpty ( Werkbon::Project_id ) ]
                  Go To Related Record [Show only related records; From table: Werkbon; Using layout: "Werkbon" (Werkbon) ]
                  Show Omitted Only
               Else
                  Go To Layout [ "Werkbon" (Werkbon)]
                  Show All Records
               End If

               If executed from a layout based on VoorCal, will pull up all records in Werkbon that do not have a matching project_id.