Delay in look up

[Logixx]

Hi.

I'm working on a complex solution in which I strangely meet a delay in a look-up.

I've been able to reproduce it in a small file, please see attachment.

We have 3 tables: People, Sessions and Jobs.

We have 2 one-to-many relationships.

Now we need to capture the age of people at time of each particular job. One session may last for weeks - thus age may change from job to job in one session. Age is then part of a multi criteria relationship (not reproduced in the attachment).

To capture that age, we use a look up from People, which is 2 tables away.

Here we have delays...

Can you reproduce it in your system? Do I miss something in my db design?

Too_bad_delay.fp7.zip