6 Replies Latest reply on Dec 16, 2016 6:42 AM by philmodjunk

    Lookup Surname

    rozmario

      It might be a silly question, but I am a newbie, I have a relationship between table A ( shipments ) and table B ( contacts) with a lookup I  search the Surname however when I found two identical surname the second does not appear.

      How can I solve the relationship and show everything ?

      I am publishing the db on webdirect

       

      Thank You

        • 1. Re: Lookup Surname
          hankshrier

          To help you, we need to know what fields you are using to link the two tables. Also, does your contacts table have a more than one "Name "Field?  IE First_Name,  Middle_Name,  Last_Name.
          field in both tables that identifies the person with a unique id.  (Contact_id) 

           

          Are you using a field in both tables that identifies the person with a unique id.  (Contact_id) ?

           

          You have an easy to solve problem once you explain the desired result.

           

           

           

           

           

           

          You also mentioned you are using a look up.  Can you clarify what you actually what the end result to be.

          • 2. Re: Lookup Surname
            rozmario

            Ok

            First I am using the surname field to link the two table.

            Yes I have a First_Name, Badge_id, email, and I do have a Contact_id.

            I need to look/search the surname e fill the First_Name, email and so on ... fields.

            Thank again

            • 3. Re: Lookup Surname
              philmodjunk

              If you were performing a find by surname you would find all records with that surname in your found set.

               

              If you used a relationship to set up a portal, you would see all related records with that surname in your portal.

               

              But if you set up a calculation that refers to the records in the related table, with most expressions that might reference fields in the related table, the expression just references data in the first related record. Certain aggregate functions such as List could, on the other hand, return data based on all the related records.

               

              A value list based on Surname in many cases would also show just one instance of any one surname value.

               

              From what you describe, it sounds like you might set up a portal listing all records with a surname entered by the users with buttons in the portal row (or the fields of the portal row set up as a button), that then enables the user to enter data from the portal row that they choose to click.

              • 4. Re: Lookup Surname
                hankshrier

                To link the two tables you need a unique ID. Go back and create the field Customer_Id, or whatever else you want to use. Create the field in both tables.  In the contacts table, be sure to set the validation to require a unique value.  In the contacts table, Auto enter a serial number in the Customer_id field.
                be to

                 

                The trick will be to replace the ids in the 2nd table

                • 5. Re: Lookup Surname
                  erolst

                  rozmario wrote:

                  First I am using the surname field to link the two table.

                  Not really a good idea.

                   

                  Read up on primary keys, e.g. here: Confluence Mobile - FileMaker Coding Standards

                  • 6. Re: Lookup Surname
                    philmodjunk

                    Actually, linking by surname can be useful, but only as a way to get a list from which to select a record and get it's primary key copied over to a foreign key. In other words, a special use relationship used during data entry to set up a proper primary key to foreign key relationship.