I have a look up happening between two databases that is troublesome. When I create a new record, the look-up doesn't happen. If I move on, define fields or something (haven't found trigger) and come back, the values are then populated. I have other look-ups happening using different relationships that work fine. Anyone have any ideas why these won't happen. BTW the relationship is an indexed calculation with a value of 1 between both databases. Like the cartesian X value between relationships.

Have you tried the Cartesian X for this relationship? You could elminate the calculated fields now used.

I suppose you make use of 2 separated files. I have seen the same behaviour. I think it's a refresh bug in FileMaker Pro. If someone else logs in in the same file, he will see the right data. This behaviour only appears when you use different files. Within a file there is no problem.

You can use an "auto enter" function instead of an lookup. With the auto-enter function you haven't this behaviour.

We have discussed this issue on a dutch spoken FileMaker forum where you can download a sample of a workaround: http://www.clarify.net/viewtopic.php?t=1646

Koen

i'm taking a look at this file as well (i work with him) and i got the lookups to work correctly on the fields he was having troubles with but now i'm having issues with related fields showing up. if i relookup the data the related fields appear, and if i go to define relationships it will appear (but after 6 seconds, i timed it).

we installed from the same disc, could that be the problem?