1 Reply Latest reply on Dec 19, 2011 2:39 PM by mgores

    Creating Look Up Field

    JohnHollingsworth

      Title

      Creating Look Up Field

      Post

      Hi,

      I'm a FM beginner trying to get my head around this....

       

      I havw two tables (Contacts & Enquiries)  What I am trying to do is to create a field in the enquiries table that I can pick which customer the enquiry relates to.  Can somebody let me know how to achieve this?

       

      Many thanks

       

      Jay 

        • 1. Re: Creating Look Up Field
          mgores

          You should have a serial number field for contacts, if you don't have one it is easy to add one.  It should be an auto entered serial number.  Say Contact ID

          You then create a number field in Enquiries, Contact ID  ( some use a prefix of pK of fK to indicate primary key and foreign key)

          Then relate the two tables by those ID fields, use the allow creation of records via this relationship on the Enquiries side.