4 Replies Latest reply on May 5, 2017 5:02 PM by philmodjunk

    Filemaker Look up

    muhammad.ikram@contedia.com

      Hello Community,

       

      Small question about FileMaker Lookups.

       

      I have 2 tables orders and assets. When Order gets delivered to customer, it becomes customer assets.

       

      I attach serial numbers to orders before I send them to customers. I also have an serial No field in assets table which use "Lookup" for serial number from orders table using the relationship.

       

      All works fine.

       

      Small problem is if I receive an order and DO NOT ENTER SERIAL NUMBER and dispatch to customer. Maybe after a week, I go back and enter the serial number to that order than It doesn't show the serial number in asserts table.

       

      If I enter serial number soon I receive an order, the Lookup will work but If I go back to that order After few days, When I enter serial number, than it doesn't show on assets table.

       

      Is there any limitations for Lookup??

       

      Thank you in advance.