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.