AnsweredAssumed Answered

Filemaker Look up

Question asked by muhammad.ikram@contedia.com 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.

Outcomes