3 Replies Latest reply on Aug 14, 2013 1:23 PM by philmodjunk

    Autofill Name field and related fields based on ID relationship

    swillette

      Title

      Autofill Name field and related fields based on ID relationship

      Post

           I read post:

           http://forums.filemaker.com/posts/af6741af16

           I understand and use this in regards to using the IDs for each side of the relation, but my user wants to type in the name field (autofill) and have all the related fields flow in. The name field is not the field that the relation is based on. The relationship is based on CustomerIDpk and CustomerIDfk.

           I've tried a drop down with CustomerID and Name showing, but the user wants to type in the customer's name in the name field for the autofill.

           I'm using lookup values so I can get the customer name in the name field to fill in if they are in the database, but if I select that user, the rest of the fields do not fill in. 

           Any way to fix this? Thanks Steve

           I'm using FileMaker Pro 12 Advanced on a Mac.