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

    Filemaker Look up


      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.