AnsweredAssumed Answered

Filemaker Look up

Question asked by on May 5, 2017
Latest reply on May 5, 2017 by philmodjunk

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.