1 Reply Latest reply on Oct 24, 2008 12:21 PM by Stephen Huston

    I'm really confused about relationships...and I don't just mean personal....

    fototakr

      Title

      I'm really confused about relationships...and I don't just mean personal....

      Post

      I've been using filemaker since the very beginning, when I had to hand crank my computer to start it up (fine, my attempt at computer humor).

      I designed and have been using it for my invoices very nicely but have decided to design a new form.  That being done, I can't figure out for the life of me how to create the lookup files so that when I enter in and account number (using their phone number) all the rest of the info is entered into the proper fields.  

       

      It use to be so easy, but now.....not so much.  

       

      Any help would be appreciated.

       

      thanks

        • 1. Re: I'm really confused about relationships...and I don't just mean personal....
          Stephen Huston
            

          The ability to autoenter data from a related field is still there if you actually need to capture and store the related data in the local table. [Keep in mind that you can simply place the related field on the layout if you don't mind it updating if something changes in the related record.]

           

          To capture current data and preserve it at the time the record was created, I use the Autoenter data by calculation and reference to related field in the calculation. Depending on the nature of what you are capturing, you may need to use the Evaluate function within the autoenter calculation.

           

          Stephen